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");