sqlexpr

Version 2.2.1

A Python library for programmatically building SQL queries. It produces well-formatted, readable SQL with proper indentation and line wrapping.

• About
  • Authors
  • License
• Getting Started
  • Purpose
  • Real-World Example
  • Design
  • Installation
  • Basic Usage
  • Comments
  • Executing Queries
  • Parameter Styles
• SELECT Queries
  • Basic Select
  • Multiple Columns
  • DISTINCT
  • Tables and Joins
  • WHERE Clause
  • GROUP BY and HAVING
  • ORDER BY, LIMIT, OFFSET
  • WINDOW Clauses
  • Common Table Expressions (WITH)
  • UNION and Set Operations
  • SELECT INTO
  • FETCH
  • FOR UPDATE / Locking
  • Subqueries
• INSERT Queries
  • Basic Insert
  • Multiple Columns (kwargs)
  • Columns and Values
  • Values Only
  • DEFAULT VALUES
  • Multiple Rows
  • INSERT from SELECT
  • Table Alias
  • ON CONFLICT (Upsert)
  • WITH Clause
  • RETURNING
• UPDATE Queries
  • Basic Update
  • Multiple Assignments
  • Column-List Syntax
  • FROM Clause
  • UPDATE ONLY
  • WITH Clause
  • RETURNING
• DELETE Queries
  • Basic Delete
  • Delete All Rows
  • RETURNING
  • USING
  • DELETE ONLY
  • WITH Clause
• CREATE TABLE Queries
  • Basic Table
  • IF NOT EXISTS
  • UNLOGGED
  • TEMPORARY
  • Table Constraints
  • LIKE
  • INHERITS
  • PARTITION BY
  • TABLESPACE
• DROP TABLE
  • Basic Drop
  • IF EXISTS
  • Multiple Tables
  • CASCADE
• CREATE INDEX
  • Basic Index
  • Unique Index
  • INCLUDE
  • USING (Index Method)
  • Partial Index (WHERE)
  • CONCURRENTLY
  • Expression Index
  • Storage Parameters
  • TABLESPACE
  • NULLS NOT DISTINCT
  • Column Options
• BULK COPY
  • Basic Usage
  • NULL Values
  • Escaping
  • Row Count
• Expressions
  • SqlTerm
  • SqlAnd / SqlOr
  • SqlValue
  • SqlCat
  • SqlColumn
• Formatting
  • Basic Usage
  • Options
  • Line Wrapping
  • Parameter Styles
    • format (%s) — PG, MYSQL, MSSQL
    • qmark (?) — SQLITE
    • named (:name) — ORACLE
    • numeric (:1, :2) — ORACLE
    • pyformat (%(name)s) — PG, MYSQL
    • Named Parameter Deduplication
  • Template Mode
    • Positional template
    • Named template
• Supporting Multiple SQL Dialects
  • Available Dialects
  • Usage
  • Design Principles
  • Placeholder Styles
  • Dialect-Specific Features
  • Adding a New Dialect
  • Module Structure
• API Reference
• Glossary