Query Language Snippets
All Snippets
SQLModel
Delete
Delete a record using SQLModel.
with Session(engine) as session:
user = session.exec(select(User).where(User.name == 'Alice')).first()
session.delete(user)
session.commit()
SQLAlchemy
Delete
Delete a record using SQLAlchemy.
user = session.query(User).filter_by(name='Alice').first()
session.delete(user)
session.commit()
Cypher
Delete
Delete a node and its relationships.
MATCH (n:Person {name: 'Bob'})
DETACH DELETE n;
MongoDB
Delete
Delete a document.
db.users.deleteOne({ name: "Alice" });
GraphQL
Read
Use inline fragments for type-specific fields.
query {
search {
__typename
... on User {
name
}
... on Post {
title
}
}
}
GraphQL
Read
Nested query with arguments.
query {
users(limit: 1) {
id
name
todos(order_by: {created_at: desc}, limit: 5) {
id
title
}
}
}
GraphQL
Read
Use directives for conditional logic (@include, @skip).
query getUser($withEmail: Boolean!) {
user(id: 5) {
name
email @include(if: $withEmail)
}
}
GraphQL
Read
Query with fragments for reusability.
fragment userFields on User {
id
name
email
}
query {
users {
...userFields
posts {
id
title
}
}
}
GraphQL
Read
Query with aliasing to rename fields.
query {
post1: post(id: 1) { title }
post2: post(id: 2) { title }
}
SQL
Read
Filter records with set membership (IN).
SELECT * FROM products WHERE id IN (1, 2, 3);
GraphQL
Read
Query with variables for dynamic input.
query GetUser($userId: Int!) {
user(id: $userId) {
name
email
}
}
MongoDB
Read
Use distinct to find unique values for a field.
db.users.distinct("city");