Query Language Snippets

Reset
All Snippets
SQLModel Read
Query records with a filter using SQLModel.
from sqlmodel import select
with Session(engine) as session:
    users = session.exec(select(User).where(User.age > 25)).all()
    for user in users:
        print(user.name, user.age)
SQLModel Read
Use SQLModel for aggregations.
from sqlmodel import func
with Session(engine) as session:
    avg_age = session.exec(select(func.avg(User.age))).one()
    print(f'Average age: {avg_age}')
SeaORM Read
Query all records using SeaORM.
use sea_orm::EntityTrait;

let users = Entity::find().all(&db).await?;
for user in users {
    println!("{}: {}", user.name, user.age);
}
SeaORM Read
Query records with a filter using SeaORM.
use sea_orm::{EntityTrait, Condition};

let users = Entity::find()
    .filter(Condition::all().add(Column::Age.gt(25)))
    .all(&db)
    .await?;
for user in users {
    println!("{}: {}", user.name, user.age);
}
SeaORM Read
Use SeaORM for aggregations.
use sea_orm::{EntityTrait, QuerySelect, QueryTrait};

let avg_age = Entity::find()
    .select_only()
    .column_as(Column::Age.avg(), "avg_age")
    .into_tuple::<f64>()
    .one(&db)
    .await?;
println!("Average age: {:?}", avg_age);
SQLx Read
Query all records using SQLx.
let users = sqlx::query_as::<_, User>("SELECT id, name, age FROM users")
    .fetch_all(&pool)
    .await?;

for user in users {
    println!("{}: {}", user.name, user.age);
}
SQLx Read
Query records with a filter using SQLx.
let users = sqlx::query_as::<_, User>(
    "SELECT id, name, age FROM users WHERE age > $1"
)
.bind(25)
.fetch_all(&pool)
.await?;

for user in users {
    println!("{}: {}", user.name, user.age);
}
SQLx Read
Use SQLx for aggregations.
let avg_age: f64 = sqlx::query_scalar(
    "SELECT AVG(age) FROM users"
)
.fetch_one(&pool)
.await?;

println!("Average age: {}", avg_age);
SQL Read
Select all columns from a table.
SELECT * FROM table_name;
SQL Sort
Sort results in ascending/descending order.
SELECT * FROM orders ORDER BY order_date DESC;
SELECT * FROM orders ORDER BY order_date ASC;
Kusto Sort
Use sort for ordering results.
StormEvents | sort by StartTime desc | take 10
Cypher Sort
Use ORDER BY, LIMIT, and SKIP for pagination.
MATCH (p:Person)
RETURN p.name
ORDER BY p.age DESC
SKIP 0 LIMIT 10;