Query Language Snippets

Reset
All Snippets
SQL Create
Create a new table with columns and constraints.
CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(255) UNIQUE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
SQLAlchemy Create
Insert a single record using SQLAlchemy.
user = User(name='Alice', age=30)
session.add(user)
session.commit()
SQLAlchemy Create
Create all tables in the database.
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)
session = Session()
Base.metadata.create_all(engine)
Cypher Create
Create an index for faster queries.
CREATE INDEX FOR (n:Person) ON (n.name);
SQLModel Create
Create a SQLModel engine and tables.
from sqlmodel import create_engine, Session
engine = create_engine('sqlite:///example.db')
SQLModel.metadata.create_all(engine)
SQLModel Create
Define a SQLModel model.
from sqlmodel import SQLModel, Field

class User(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    name: str
    age: int
SQLx Create
Define a SQLx model.
use serde::{Deserialize, Serialize};

#[derive(Debug, Serialize, Deserialize, sqlx::FromRow)]
pub struct User {
    pub id: i32,
    pub name: String,
    pub age: i32,
}
SQL Create
Create an index on a column for faster queries.
CREATE INDEX idx_name ON users(name);
SQL Delete
Delete specific rows from a table.
DELETE FROM products WHERE price < 1.00;
SeaORM Delete
Delete a record using SeaORM.
use sea_orm::{EntityTrait, ColumnTrait, QueryFilter};

let user = Entity::find()
    .filter(Column::Name.eq("Alice"))
    .one(&db)
    .await?;

if let Some(user) = user {
    user.delete(&db).await?;
}
SQL Delete
Drop a table.
DROP TABLE users;
SQLAlchemy Delete
Delete a record using SQLAlchemy.
user = session.query(User).filter_by(name='Alice').first()
session.delete(user)
session.commit()