SQLGlot Dialects
from sqlspec.dialects import (
DB2,
ParadeDB,
PGTextSearch,
PGVector,
Spangres,
Spanner,
SQLAnywhere,
Sybase,
Teradata,
)
Custom SQLGlot dialect implementations registered automatically via Python entry points (sqlglot.dialects) when SQLSpec is installed. See the Query Builder Guide for syntax translations and dialect features.
Cloud Spanner Dialects
Spanner
Bases: BigQuery
Google Cloud Spanner SQL dialect.
Tokenizer
Tokenizer = SpannerTokenizer
Generator
Generator = SpannerGenerator
parse
Parse Spanner SQL statements and attach hints.
parse_into
parse_into(expression_type, sql, **opts)
Parse into specific expression type with attached hints.
Spangres
Bases: Postgres
Spanner PostgreSQL-compatible dialect.
Generator
Generator = SpangresGenerator
parse
Parse Spangres SQL statements and attach hints.
parse_into
parse_into(expression_type, sql, **opts)
Parse into specific expression type with attached hints.
Sybase ASE & SAP SQL Anywhere Dialects
Sybase
Bases: TSQL
SAP Adaptive Server Enterprise (Sybase ASE) SQL dialect.
NORMALIZATION_STRATEGY
NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
Tokenizer
Tokenizer = SybaseTokenizer
Generator
Generator = TSQL.Generator
generator
Return a generator whose dispatch table carries the Sybase ASE handlers.
parse
Parse Sybase ASE SQL and normalize ASE function nodes.
parse_into
parse_into(expression_type, sql, **opts)
Parse Sybase ASE SQL into a target expression type.
SQLAnywhere
Bases: TSQL
SAP SQL Anywhere SQL dialect.
NORMALIZATION_STRATEGY
NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
Tokenizer
Tokenizer = SQLAnywhereTokenizer
Generator
Generator = TSQL.Generator
generator
Return a generator whose dispatch table carries the SAP SQL Anywhere handlers.
parse
Parse SAP SQL Anywhere SQL and normalize SQL Anywhere function nodes.
parse_into
parse_into(expression_type, sql, **opts)
Parse SAP SQL Anywhere SQL into a target expression type.
IBM Db2 Dialect
DB2
Bases: Dialect
IBM Db2 SQL dialect.
NORMALIZATION_STRATEGY
NORMALIZATION_STRATEGY = NormalizationStrategy.UPPERCASE
NULL_ORDERING
NULL_ORDERING = 'nulls_are_large'
TIME_MAPPING
TIME_MAPPING = DB2_TIME_MAPPING
INVERSE_TIME_MAPPING
INVERSE_TIME_MAPPING = DB2_INVERSE_TIME_MAPPING
Generator
Generator = generator.Generator
generator
Return a root generator whose dispatch table carries the Db2 handlers.
Parameters:
| Name |
Type |
Description |
Default |
**opts
|
Any
|
sqlglot generator options.
|
{}
|
Returns:
| Type |
Description |
Generator
|
A generator that renders Db2 SQL.
|
parse
Parse Db2 SQL, including Db2 select-statement tails.
Parameters:
| Name |
Type |
Description |
Default |
sql
|
str
|
|
required
|
**opts
|
Any
|
|
{}
|
Returns:
| Type |
Description |
list[Expr | None]
|
One expression per statement.
|
parse_into
parse_into(expression_type, sql, **opts)
Parse Db2 SQL into a target expression type, including statement tails.
Parameters:
| Name |
Type |
Description |
Default |
expression_type
|
Any
|
Target sqlglot expression type or types.
|
required
|
sql
|
str
|
|
required
|
**opts
|
Any
|
|
{}
|
Returns:
| Type |
Description |
list[Expr | None]
|
One expression per statement.
|
Teradata Vantage Dialect
SQLSpec registers its Teradata dialect with sqlglot as vantage and leaves sqlglot's built-in teradata dialect unchanged. SQLSpec builders, statement configs, and the Teradata adapters resolve teradata to vantage; call sqlglot with vantage directly to get the same output.
Vantage
Bases: Teradata
Generate Vantage SQL through an isolated dispatch overlay.
Tokenizer
Tokenizer = VantageTokenizer
Generator
Generator = UpstreamTeradata.Generator
generator
Create a generator with Vantage pagination and type handlers.
PostgreSQL Search & Vector Dialects
PGVector
Bases: Postgres
PostgreSQL dialect with pgvector extension support.
Tokenizer
Tokenizer = PGVectorTokenizer
Generator
Generator = PGVectorGenerator
ParadeDB
Bases: Postgres
ParadeDB dialect with pg_search and pgvector extension support.
Tokenizer
Tokenizer = ParadeDBTokenizer
Generator
Generator = ParadeDBGenerator
PGTextSearch
Bases: Postgres
PostgreSQL dialect with pg_textsearch and pgvector extension support.
Tokenizer
Tokenizer = PGTextSearchTokenizer
Generator
Generator = PGTextSearchGenerator