GeezerVison is showing sqlspec.dev — Dialects - SQLSpec
SQLGlot Dialects¶
from sqlspec.dialects import (
DB2,
ParadeDB,
PGTextSearch,
PGVector,
Spangres,
Spanner,
SQLAnywhere,
Sybase,
)
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¶
Bases: BigQuery
Google Cloud Spanner SQL dialect.
Tokenizer = SpannerTokenizer
Generator = SpannerGenerator
Parse Spanner SQL statements and attach hints.
parse_into(expression_type, sql, **opts)
Parse into specific expression type with attached hints.
Bases: Postgres
Spanner PostgreSQL-compatible dialect.
Generator = SpangresGenerator
Parse Spangres SQL statements and attach hints.
parse_into(expression_type, sql, **opts)
Parse into specific expression type with attached hints.
Sybase ASE & SAP SQL Anywhere Dialects¶
Bases: TSQL
SAP Adaptive Server Enterprise (Sybase ASE) SQL dialect.
NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
Tokenizer = SybaseTokenizer
Generator = TSQL.Generator
Return a generator whose dispatch table carries the Sybase ASE handlers.
Parse Sybase ASE SQL and normalize ASE function nodes.
parse_into(expression_type, sql, **opts)
Parse Sybase ASE SQL into a target expression type.
Bases: TSQL
SAP SQL Anywhere SQL dialect.
NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
Tokenizer = SQLAnywhereTokenizer
Generator = TSQL.Generator
Return a generator whose dispatch table carries the SAP SQL Anywhere handlers.
Parse SAP SQL Anywhere SQL and normalize SQL Anywhere function nodes.
parse_into(expression_type, sql, **opts)
Parse SAP SQL Anywhere SQL into a target expression type.
IBM Db2 Dialect¶
Bases: Dialect
IBM Db2 SQL dialect.
NORMALIZATION_STRATEGY = NormalizationStrategy.UPPERCASE
NULL_ORDERING = 'nulls_are_large'
TIME_MAPPING = DB2_TIME_MAPPING
INVERSE_TIME_MAPPING = DB2_INVERSE_TIME_MAPPING
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 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(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.
|
PostgreSQL Search & Vector Dialects¶
Bases: Postgres
PostgreSQL dialect with pgvector extension support.
Tokenizer = PGVectorTokenizer
Generator = PGVectorGenerator
Bases: Postgres
ParadeDB dialect with pg_search and pgvector extension support.
Tokenizer = ParadeDBTokenizer
Generator = ParadeDBGenerator
Bases: Postgres
PostgreSQL dialect with pg_textsearch and pgvector extension support.
Tokenizer = PGTextSearchTokenizer
Generator = PGTextSearchGenerator