🥮 mooncakes.io

    bobzhang/sqlglot/core does not have a README file

    ColumnOpFn

    source
    type ColumnOpFn = (Parser, Expr?, Expr?) -> Expr? raise SqlglotError

    COLUMN_OPERATORS / JSON_OPERATORS value: (self, this, rhs) -> Expr.

    FuncBuilder

    source
    type FuncBuilder = (Array[Expr], Parser) -> Expr raise SqlglotError

    A function builder: FUNCTIONS[name](args).

    GenExprFn

    source
    type GenExprFn = (Generator, Expr) -> Expr raise SqlglotError

    GenFn

    source
    type GenFn = (Generator, Expr) -> String raise SqlglotError

    ParseFn

    source
    type ParseFn = (Parser) -> Expr? raise SqlglotError

    ParseFn1

    source
    type ParseFn1 = (Parser, Expr?) -> Expr? raise SqlglotError

    PropKwargs

    source
    type PropKwargs = Map[String, Bool]

    Keyword arguments passed to property parsers (no=True, dual=True, ...).

    PropLocs

    source
    type PropLocs = Map[PropertiesLocation, Array[Expr]]

    Result of locate_properties: properties grouped by their location.

    PropertyFn

    source
    type PropertyFn = (Parser, Map[String, Bool]) -> Value? raise SqlglotError

    A property parser may return an expression, a list of expressions or nothing.

    TokenParseFn

    source
    type TokenParseFn = (Parser, Token) -> Expr? raise SqlglotError

    Transform

    source
    type Transform = (Expr) -> Expr raise SqlglotError

    IntoPy

    source
    pub(open) trait IntoPy {
      fn into_py(Self) -> PyObj
    }

    Conversion of MoonBit values into host values (PyObj).
    impl IntoPy for Bool
    impl IntoPy for Int
    impl IntoPy for Int64
    impl IntoPy for Double
    impl IntoPy for String
    impl IntoPy for Option[T]
    impl IntoPy for Bytes
    impl IntoPy for Array[T]
    impl IntoPy for Map[String, V]

    IntoValue

    source
    pub trait IntoValue {
      fn into_value(Self) -> Value?
    }

    Conversion of host values to expression argument values.
    impl IntoValue for Bool
    impl IntoValue for Int
    impl IntoValue for Int64
    impl IntoValue for String
    impl IntoValue for Option[T]
    impl IntoValue for Array[T]

    SqlArg

    source
    pub trait SqlArg {
      fn arg_sql(Self, Generator) -> String? raise SqlglotError
    }

    An argument of func / format_args: an expression, a SQL string or None.
    impl SqlArg for String
    impl SqlArg for Option[T]

    SqlglotError

    source
    pub(all) suberror SqlglotError {
      TokenError(String, start~ : Int?, end~ : Int?)
      ParseError(String, Array[ParseErrorInfo])
      UnsupportedError(String)
      OptimizeError(String)
      SchemaError(String)
      ExecuteError(String)
      ValueError(String)
    }

    Errors raised by sqlglot.

    SqlglotError::message

    source
    fn SqlglotError::message(self : SqlglotError) -> String

    DType

    source
    pub(all) enum DType {
      ARRAY
      AGGREGATEFUNCTION
      SIMPLEAGGREGATEFUNCTION
      BIGDECIMAL
      BIGINT
      BIGNUM
      BIGSERIAL
      BINARY
      BIT
      BLOB
      BOOLEAN
      BPCHAR
      CHAR
      CHARACTER_SET
      DATE
      DATE32
      DATEMULTIRANGE
      DATERANGE
      DATETIME
      DATETIME2
      DATETIME64
      DECIMAL
      DECIMAL32
      DECIMAL64
      DECIMAL128
      DECIMAL256
      DECFLOAT
      DOUBLE
      DYNAMIC
      ENUM
      ENUM8
      ENUM16
      FILE
      FIXEDSTRING
      FLOAT
      GEOGRAPHY
      GEOGRAPHYPOINT
      GEOMETRY
      POINT
      RING
      LINESTRING
      MULTILINESTRING
      POLYGON
      MULTIPOLYGON
      HLLSKETCH
      HSTORE
      IMAGE
      INET
      INT
      INT128
      INT256
      INT4MULTIRANGE
      INT4RANGE
      INT8MULTIRANGE
      INT8RANGE
      INTERVAL
      IPADDRESS
      IPPREFIX
      IPV4
      IPV6
      JSON
      JSONB
      LIST
      LONGBLOB
      LONGTEXT
      LOWCARDINALITY
      MAP
      MEDIUMBLOB
      MEDIUMINT
      MEDIUMTEXT
      MONEY
      NAME
      NCHAR
      NESTED
      NOTHING
      NULL
      NUMMULTIRANGE
      NUMRANGE
      NVARCHAR
      OBJECT
      RANGE
      ROWVERSION
      SERIAL
      SET
      SMALLDATETIME
      SMALLINT
      SMALLMONEY
      SMALLSERIAL
      STRUCT
      SUPER
      TEXT
      TINYBLOB
      TINYTEXT
      TIME
      TIMETZ
      TIME_NS
      TIMESTAMP
      TIMESTAMPNTZ
      TIMESTAMPLTZ
      TIMESTAMPTZ
      TIMESTAMP_S
      TIMESTAMP_MS
      TIMESTAMP_NS
      TINYINT
      TSMULTIRANGE
      TSRANGE
      TSTZMULTIRANGE
      TSTZRANGE
      UBIGINT
      UINT
      UINT128
      UINT256
      UMEDIUMINT
      UDECIMAL
      UDOUBLE
      UNION
      UNKNOWN
      USERDEFINED
      USMALLINT
      UTINYINT
      UUID
      VARBINARY
      VARCHAR
      VARIANT
      VECTOR
      XML
      YEAR
      TDIGEST
    } derive(Compare, Eq, Hash)

    impl IntoPy for DType
    impl IntoValue for DType
    impl Show for DType

    DType::id

    source
    fn DType::id(self : DType) -> Int

    DType::into_expr

    source
    fn DType::into_expr(self : DType) -> Expr

    Python DType.into_expr().

    DType::name

    source
    fn DType::name(self : DType) -> String

    DType::value

    source
    fn DType::value(self : DType) -> String

    The SQL value of a data type, e.g. DOUBLE PRECISION style names are kept as in Python.

    Dialect

    source
    pub struct Dialect {
      name : String
      cfg : DialectConfig
      tokenizer : TokenizerSettings
      jsonpath_tokenizer : TokenizerSettings
      jsonpath_var_tokens : Array[TokenType]
      parser_cfg : ParserConfig
      parser_fns : ParserFns
      gen_cfg : GeneratorConfig
      gen_fns : GeneratorFns
      hooks : DialectHooks
      normalization_strategy : NormalizationStrategy
      version : (Int, Int, Int)
      settings : Map[String, String]
      supported_settings : Array[String]
      time_trie : Trie
      format_trie : Trie
      inverse_time_trie : Trie
      inverse_format_trie : Trie
      parent : Dialect?
    }

    A SQL dialect: the Python Dialect class plus its Tokenizer, Parser and Generator configuration.
    impl Eq for Dialect
    impl Show for Dialect

    Dialect::base

    source
    fn Dialect::base() -> Dialect

    Builds the base ("sqlglot") dialect.

    Dialect::can_quote

    source
    fn Dialect::can_quote(self : Dialect, identifier : Expr, identify? : String) -> Bool

    Checks if an identifier can be quoted. identify is "always", "safe" or "unsafe".

    Dialect::can_quote_base

    source
    fn Dialect::can_quote_base(self : Dialect, identifier : Expr, identify? : String) -> Bool

    Dialect::case_sensitive

    source
    fn Dialect::case_sensitive(self : Dialect, text : String) -> Bool

    Checks if text contains any case sensitive characters.

    Dialect::finalize

    source
    fn Dialect::finalize(self : Dialect) -> Dialect

    Recomputes derived tables after the configuration has been modified.

    Dialect::format_time

    source
    fn Dialect::format_time(self : Dialect, expression : Expr?) -> Expr?

    Converts a time format in this dialect to a python/strftime time format.

    Dialect::format_time_str

    source
    fn Dialect::format_time_str(self : Dialect, s : String) -> Expr

    Dialect.format_time with a quoted python string (e.g. "'%Y-%m-%d'").

    Dialect::generate_sql

    source
    fn Dialect::generate_sql(self : Dialect, expression : Expr) -> String raise SqlglotError

    Python Dialect.generate(expression) / expression.sql(dialect) with default options.

    Dialect::generate_values_aliases

    source
    fn Dialect::generate_values_aliases(self : Dialect, expression : Expr) -> Array[Expr]

    Dialect::get_or_raise

    source
    fn Dialect::get_or_raise(spec : String) -> Dialect raise SqlglotError

    Look up a dialect in the global registry. The string can be followed by settings, e.g. "mysql, normalization_strategy = case_sensitive".

    Dialect::instance

    source
    fn Dialect::instance(self : Dialect) -> Dialect

    Returns a shallow instance copy (shares class-level configuration) so that instance settings can be changed without affecting the registered dialect. Like Python's Dialect.__init__, the instance's normalization strategy defaults to the class-level NORMALIZATION_STRATEGY (cfg).

    Dialect::normalize_identifier

    source
    fn Dialect::normalize_identifier(self : Dialect, expression : Expr) -> Expr

    Transforms an identifier in a way that resembles how it'd be resolved by this dialect.

    Dialect::normalize_identifier_base

    source
    fn Dialect::normalize_identifier_base(self : Dialect, expression : Expr) -> Expr

    Dialect::parse

    source
    fn Dialect::parse(self : Dialect, sql : String, error_level? : ErrorLevel, error_message_context? : Int, max_errors? : Int, max_nodes? : Int) -> Array[Expr?] raise SqlglotError

    Parses sql into a list of syntax trees, one per statement.

    Dialect::parse_into

    source
    fn Dialect::parse_into(self : Dialect, into : Array[Kind], sql : String, error_level? : ErrorLevel, error_message_context? : Int, max_errors? : Int, max_nodes? : Int, into_is_list? : Bool) -> Array[Expr?] raise SqlglotError

    Parses sql into the given expression type(s).

    Dialect::parser

    source
    fn Dialect::parser(self : Dialect, error_level? : ErrorLevel, error_message_context? : Int, max_errors? : Int, max_nodes? : Int) -> Parser

    Creates a parser for this dialect.

    Dialect::quote_identifier

    source
    fn Dialect::quote_identifier(self : Dialect, expression : Expr, identify? : Bool) -> Expr

    Adds quotes to a given identifier.

    Dialect::subclass

    source
    fn Dialect::subclass(parent : Dialect, name : String, configure : (Dialect) -> Unit) -> Dialect

    Derives a new dialect from parent: copies all of its configuration, then applies configure and recomputes derived tables.

    Dialect::to_json_path

    source
    fn Dialect::to_json_path(self : Dialect, path : Expr?) -> Expr? raise SqlglotError

    Dialect.to_json_path(path): parses string/number literals into JSONPath expressions.

    Dialect::to_json_path_base

    source
    fn Dialect::to_json_path_base(self : Dialect, path : Expr?) -> Expr? raise SqlglotError

    The base Dialect.to_json_path implementation.

    Dialect::tokenize

    source
    fn Dialect::tokenize(self : Dialect, sql : String) -> Array[Token] raise SqlglotError

    Tokenizes sql with this dialect's tokenizer (virtual: see DialectHooks::tokenize).

    Dialect::tokenize_base

    source
    fn Dialect::tokenize_base(self : Dialect, sql : String) -> Array[Token] raise SqlglotError

    Tokenizes sql with this dialect's tokenizer settings.

    DialectConfig

    source
    pub(all) struct DialectConfig {
      alias_post_tablesample : Bool
      alias_post_version : Bool
      alter_table_add_required_for_each_column : Bool
      alter_table_supports_cascade : Bool
      annotate_all_scopes : Bool
      array_agg_includes_nulls : Bool?
      array_funcs_propagates_nulls : Bool
      ascii_only_normalization : Bool
      bit_end : String?
      bit_start : String?
      byte_end : String?
      byte_start : String?
      byte_strings_support_escaped_sequences : Bool
      byte_string_is_bytes_type : Bool
      coalesce_comparison_non_standard : Bool
      concat_coalesce : Bool
      concat_ws_coalesce : Bool
      copy_params_are_csv : Bool
      creatable_kind_mapping : Map[String, String]
      dateint_format : String
      date_format : String
      date_part_mapping : Map[String, String]
      default_functions_column_names : Map[Kind, String]
      default_null_type : DType
      disables_alias_ref_expansion : Bool
      dpipe_is_string_concat : Bool
      escaped_sequences : Map[String, String]
      excludes_pseudocolumns_from_star : Bool
      expand_only_group_alias_ref : Bool
      force_early_alias_ref_expansion : Bool
      format_mapping : Map[String, String]
      has_distinct_array_constructors : Bool
      hex_end : String?
      hex_lowercase : Bool
      hex_start : String?
      hex_string_is_integer_type : Bool
      identifiers_can_start_with_digit : Bool
      identifier_end : String
      identifier_start : String
      index_offset : Int
      initcap_default_delimiter_chars : String
      initcap_supports_custom_delimiters : Bool
      inverse_creatable_kind_mapping : Map[String, String]
      inverse_format_mapping : Map[String, String]
      inverse_time_mapping : Map[String, String]
      inverse_vector_type_aliases : Map[String, String]
      json_extract_scalar_scalar_only : Bool
      json_path_single_dot_is_wildcard : Bool
      least_greatest_ignores_nulls : Bool
      log_base_first : Bool?
      normalization_strategy : NormalizationStrategy
      normalize_functions : StrOrBool
      normalize_not_null : Bool
      null_ordering : String
      numbers_can_be_underscore_separated : Bool
      on_condition_empty_before_error : Bool
      prefer_cte_alias_column : Bool
      preserve_original_names : Bool
      prioritize_non_literal_types : Bool
      projection_aliases_shadow_source_names : Bool
      promote_to_inferred_datetime_type : Bool
      pseudocolumns : 
    Set    [String]
      query_results_are_structs : Bool
      quote_end : String
      quote_start : String
      regexp_extract_default_group : Int
      regexp_extract_position_overflow_returns_null : Bool
      requires_parenthesized_struct_access : Bool
      safe_division : Bool
      safe_to_eliminate_double_negation : Bool
      set_op_distinct_by_default : Map[Kind, Bool?]
      star_ilike_backslash_escape : Bool
      strict_json_path_syntax : Bool
      strict_string_concat : Bool
      strings_support_escaped_sequences : Bool
      supports_alias_refs_in_join_conditions : Bool
      supports_column_join_marks : Bool
      supports_fixed_size_arrays : Bool
      supports_limit_all : Bool
      supports_null_type : Bool
      supports_order_by_all : Bool
      supports_positional_column_refs : Bool
      supports_struct_star_expansion : Bool
      supports_user_defined_types : Bool
      supports_values_default : Bool
      tablesample_size_is_percent : Bool
      tables_referenceable_as_columns : Bool
      time_format : String
      time_mapping : Map[String, String]
      try_cast_requires_string : Bool?
      typed_division : Bool
      unescaped_sequences : Map[String, String]
      unicode_end : String?
      unicode_start : String?
      unnest_column_only : Bool
      uuid_is_string_type : Bool
      valid_interval_units : 
    Set    [String]
      week_offset : Int
    }

    Data attributes of the Python Dialect class.

    DialectConfig::copy

    source

    DialectHooks

    source
    pub(all) struct DialectHooks {
      normalize_identifier : (Dialect, Expr) -> Expr?
      generate_values_aliases : (Dialect, Expr) -> Array[Expr]?
      tokenize : (Dialect, String) -> Array[Token] raise SqlglotError?
      can_quote : (Dialect, Expr, String) -> Bool?
      to_json_path : (Dialect, Expr?) -> Expr? raise SqlglotError?
      extra : Map[String, (Dialect, Expr) -> Expr?]
    }

    Overridable dialect-level methods.

    DialectHooks::copy

    source

    DialectHooks::new

    source

    ErrorLevel

    source
    pub(all) enum ErrorLevel {
      Ignore
      Warn
      Raise
      Immediate
    } derive(Eq, Show)

    Expr

    source
    pub struct Expr {
      kind : Kind
      args : Map[String, Value]
      parent : Expr?
      arg_key : String?
      index : Int?
      comments : Array[String]?
      type_ : Expr?
      meta : Map[String, Value]?
      uid : Int
      // private fields
    }

    A node of the SQL syntax tree.
    impl IntoPy for Expr
    impl IntoValue for Expr
    impl SqlArg for Expr
    impl Eq for Expr
    impl Hash for Expr

    Expr::add

    source
    fn[T : IntoPy] Expr::add(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr + other (Expr.__add__).

    Expr::add_comments

    source
    fn Expr::add_comments(self : Expr, comments : Array[String]?, prepend? : Bool) -> Unit

    Expr::alias

    source
    fn Expr::alias(self : Expr) -> String

    The alias of the expression, or an empty string if it's not aliased.

    Expr::alias_column_names

    source
    fn Expr::alias_column_names(self : Expr) -> Array[String]

    Expr::alias_or_name

    source
    fn Expr::alias_or_name(self : Expr) -> String

    Expr::and_

    source
    fn[T : IntoPy] Expr::and_(self : Expr, expressions : Array[T], dialect? : Dialect, copy? : Bool, wrap? : Bool) -> Expr raise SqlglotError

    Expr.and_(*expressions)

    Expr::append

    source
    fn Expr::append(self : Expr, arg_key : String, value : &IntoValue) -> Unit

    Appends value to arg_key if it's a list or sets it as a new list.

    Expr::apply

    source
    fn Expr::apply(self : Expr, func : (Expr) -> Unit raise?) -> Expr raise?

    Expr.apply(func): applies func to this expression for side effects and returns it.

    Expr::arg

    source
    fn Expr::arg(self : Expr, key : String) -> Expr?

    Returns the argument key if it is an expression.

    Expr::arg_keys

    source
    fn Expr::arg_keys(self : Expr) -> Array[String]

    Python list(e.args): the argument keys, including those set to an explicit None (which come last here).

    Expr::as_

    source
    fn Expr::as_(self : Expr, alias : String, quoted? : Bool, copy? : Bool, table? : Array[String]) -> Expr

    expr.as_(alias)

    Expr::asc

    source
    fn Expr::asc(self : Expr, nulls_first? : Bool) -> Expr

    Expr.asc(nulls_first=True)

    Expr::assert_is

    source
    fn Expr::assert_is(self : Expr, kind : Kind) -> Expr raise SqlglotError

    Expr.assert_is(type_): raises if this expression isn't of kind kind.

    Expr::between

    source
    fn[L : IntoPy, H : IntoPy] Expr::between(self : Expr, low : L, high : H, copy? : Bool, symmetric? : Bool) -> Expr raise SqlglotError

    Expr.between(low, high, symmetric=...)

    Expr::bfs

    source
    fn Expr::bfs(self : Expr, prune? : (Expr) -> Bool) -> Iter[Expr]

    Iterates the tree in BFS order.

    Expr::binop

    source
    fn[T : IntoPy] Expr::binop(self : Expr, kind : Kind, other : T, reverse? : Bool) -> Expr raise SqlglotError

    Python Expr._binop(klass, other, reverse).

    Expr::bool_arg

    source
    fn Expr::bool_arg(self : Expr, key : String) -> Bool

    Returns the boolean argument key (Python truthiness).

    Expr::canonical

    source
    fn Expr::canonical(self : Expr) -> String

    Canonical dump: Kind(k=v,...) with keys in arg_types order.

    Expr::catalog

    source
    fn Expr::catalog(self : Expr) -> String

    Expr::cluster_by

    source
    fn[T : IntoPy] Expr::cluster_by(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.cluster_by(*expressions)

    Expr::column_parts

    source
    fn Expr::column_parts(self : Expr) -> Array[Expr]

    The parts of a column in order catalog, db, table, name.

    Expr::copy

    source
    fn Expr::copy(self : Expr) -> Expr

    Returns a deep copy of the expression. Like Python's Expr.__deepcopy__, the tree is copied iteratively so that very deep trees don't exhaust the stack.

    Expr::ctas

    source
    fn[T : IntoPy] Expr::ctas(self : Expr, table : T, properties? : Map[String, PyObj], dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.ctas(table, properties=...): converts this query to a CREATE TABLE AS statement.

    Expr::ctes

    source
    fn Expr::ctes(self : Expr) -> Array[Expr]

    Query.ctes

    Expr::datatype_this

    source
    fn Expr::datatype_this(self : Expr) -> DType?

    The DType stored in a DataType's this, if it's a plain type.

    Expr::db

    source
    fn Expr::db(self : Expr) -> String

    Expr::delete

    source
    fn[T : IntoPy] Expr::delete(self : Expr, table : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Delete.delete(table): sets the table to delete from.

    Expr::depth

    source
    fn Expr::depth(self : Expr) -> Int

    Depth of this node in the tree.

    Expr::desc

    source
    fn Expr::desc(self : Expr, nulls_first? : Bool) -> Expr

    Expr.desc(nulls_first=False)

    Expr::dfs

    source
    fn Expr::dfs(self : Expr, prune? : (Expr) -> Bool) -> Iter[Expr]

    Iterates the tree in DFS order.

    Expr::distinct_

    source
    fn Expr::distinct_(self : Expr, ons? : Array[&IntoPy], distinct? : Bool, copy? : Bool) -> Expr raise SqlglotError

    Select.distinct(*ons, distinct=True)

    Expr::div

    source
    fn[T : IntoPy] Expr::div(self : Expr, other : T, typed? : Bool, safe? : Bool) -> Expr raise SqlglotError

    Expr.div(other, typed=..., safe=...)

    Expr::dump

    source
    fn Expr::dump(self : Expr) -> Json

    Dumps this expression into a JSON-serializable list of payloads (Python Expr.dump).

    Expr::else_

    source
    fn[T : IntoPy] Expr::else_(self : Expr, default : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Case.else_(condition)

    Expr::eq_

    source
    fn[T : IntoPy] Expr::eq_(self : Expr, other : T) -> Expr raise SqlglotError

    expr.eq(other)

    Expr::error_messages

    source
    fn Expr::error_messages(self : Expr, nargs? : Int) -> Array[String]

    Checks the arguments of an expression for errors.

    Expr::except_

    source
    fn[T : IntoPy] Expr::except_(self : Expr, other : T, distinct? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.except_(*expressions, distinct=...)

    Expr::expression

    source
    fn Expr::expression(self : Expr) -> Expr?

    self.expression when it is an expression.

    Expr::expression_

    source
    fn Expr::expression_(self : Expr) -> Expr

    Expr::expressions

    source
    fn Expr::expressions(self : Expr) -> Array[Expr]

    self.expressions.

    Expr::find

    source
    fn Expr::find(self : Expr, kinds : ArrayView[Kind], bfs? : Bool) -> Expr?

    Returns the first node in this tree which matches at least one of the kinds.

    Expr::find_all

    source
    fn Expr::find_all(self : Expr, kinds : ArrayView[Kind], bfs? : Bool) -> Iter[Expr]

    Returns all nodes in this tree which match at least one of the kinds.

    Expr::find_ancestor

    source
    fn Expr::find_ancestor(self : Expr, kinds : ArrayView[Kind]) -> Expr?

    Returns the nearest parent matching the kinds.

    Expr::flatten

    source
    fn Expr::flatten(self : Expr, unnest? : Bool) -> Iter[Expr]

    Returns a generator which yields child nodes whose parents are the same class.

    Expr::floordiv

    source
    fn[T : IntoPy] Expr::floordiv(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr // other (Expr.__floordiv__).

    Expr::from_

    source
    fn[T : IntoPy] Expr::from_(self : Expr, expression : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.from_(expression) / Update.from_(expression)

    Expr::ge

    source
    fn[T : IntoPy] Expr::ge(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr >= other (Expr.__ge__).

    Expr::get

    source
    fn Expr::get(self : Expr, key : String) -> Value?

    Expr::get_meta

    source
    fn Expr::get_meta(self : Expr) -> Map[String, Value]

    Expr::get_type

    source
    fn Expr::get_type(self : Expr) -> Expr?

    The type property: the inferred data type of this expression.

    Expr::getitem

    source
    fn Expr::getitem(self : Expr, keys : Array[&IntoPy]) -> Expr raise SqlglotError

    Python expr[other] (Expr.__getitem__); several keys build a multi-index bracket.

    Expr::group_by

    source
    fn[T : IntoPy] Expr::group_by(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.group_by(*expressions)

    Expr::gt

    source
    fn[T : IntoPy] Expr::gt(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr > other (Expr.__gt__).

    Expr::has

    source
    fn Expr::has(self : Expr, key : String) -> Bool

    Python truthiness of self.args.get(key).

    Expr::has_key

    source
    fn Expr::has_key(self : Expr, key : String) -> Bool

    Python key in e.args: whether the argument is set, including to an explicit None (see Expr::none_keys). Use has for Python's truthiness of e.args.get(key).

    Expr::having_

    source
    fn[T : IntoPy] Expr::having_(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.having(*expressions)

    Expr::hint

    source
    fn[T : IntoPy] Expr::hint(self : Expr, hints : Array[T], dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.hint(*hints)

    Expr::ilike

    source
    fn[T : IntoPy] Expr::ilike(self : Expr, other : T) -> Expr raise SqlglotError

    Expr.ilike(other)

    Expr::intersect_

    source
    fn[T : IntoPy] Expr::intersect_(self : Expr, other : T, distinct? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.intersect(*expressions, distinct=...)

    Expr::invert

    source
    fn Expr::invert(self : Expr) -> Expr raise SqlglotError

    Python ~expr (Expr.__invert__).

    Expr::is__

    source
    fn[T : IntoPy] Expr::is__(self : Expr, other : T) -> Expr raise SqlglotError

    expr.is_(other)

    Expr::is_int

    source
    fn Expr::is_int(self : Expr) -> Bool

    Expr::is_leaf

    source
    fn Expr::is_leaf(self : Expr) -> Bool

    Expr::is_number

    source
    fn Expr::is_number(self : Expr) -> Bool

    Expr::is_star

    source
    fn Expr::is_star(self : Expr) -> Bool

    Expr::is_string

    source
    fn Expr::is_string(self : Expr) -> Bool

    Expr::is_type

    source
    fn Expr::is_type(self : Expr, dtypes : ArrayView[DType]) -> Bool

    Python Expr.is_type(*dtypes).

    Expr::is_type_expr

    source
    fn Expr::is_type_expr(self : Expr, other : Expr) -> Bool

    Python Expr.is_type(data_type_expr).

    Expr::is_wrapper

    source
    fn Expr::is_wrapper(self : Expr) -> Bool

    Whether this Subquery acts as a simple wrapper around another expression.

    Expr::isin

    source
    fn Expr::isin(self : Expr, expressions? : Array[&IntoPy], query? : &IntoPy, unnest? : Array[&IntoPy], dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Expr.isin(*expressions, query=..., unnest=...)

    Expr::iter_expressions

    source
    fn Expr::iter_expressions(self : Expr, reverse? : Bool) -> Array[Expr]

    Yields all child expressions, exploding list args.

    Expr::join_

    source
    fn[T : IntoPy] Expr::join_(self : Expr, expression : T, on? : Array[&IntoPy], using_? : Array[&IntoPy], append? : Bool, join_type? : String, join_alias? : String, side? : String, kind? : String, method? : String, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.join(expression, on=..., using=..., join_type=..., join_alias=...).

    side, kind and method directly set the corresponding join arguments.

    Expr::land

    source
    fn[T : IntoPy] Expr::land(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr & other (Expr.__and__).

    Expr::lateral

    source
    fn[T : IntoPy] Expr::lateral(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.lateral(*expressions)

    Expr::le

    source
    fn[T : IntoPy] Expr::le(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr <= other (Expr.__le__).

    Expr::like

    source
    fn[T : IntoPy] Expr::like(self : Expr, other : T) -> Expr raise SqlglotError

    Expr.like(other)

    Expr::limit_

    source
    fn[T : IntoPy] Expr::limit_(self : Expr, expression : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.limit(expression)

    Expr::list

    source
    fn Expr::list(self : Expr, key : String) -> Array[Expr]

    Returns the list argument key (only expression elements).

    Expr::load

    source
    fn Expr::load(payloads : Json) -> Expr? raise SqlglotError

    Loads a payload list produced by Expr::dump back into an expression (Python Expr.load). Returns None for an empty or null payload list.

    Expr::lock

    source
    fn Expr::lock(self : Expr, update? : Bool, copy? : Bool) -> Expr

    Select.lock(update=True)

    Expr::lor

    source
    fn[T : IntoPy] Expr::lor(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr | other (Expr.__or__).

    Expr::lt

    source
    fn[T : IntoPy] Expr::lt(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr < other (Expr.__lt__).

    Expr::meta_bool

    source
    fn Expr::meta_bool(self : Expr, key : String) -> Bool

    Expr::meta_get

    source
    fn Expr::meta_get(self : Expr, key : String) -> Value?

    Expr::mod

    source
    fn[T : IntoPy] Expr::mod(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr % other (Expr.__mod__).

    Expr::mul

    source
    fn[T : IntoPy] Expr::mul(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr * other (Expr.__mul__).

    Expr::name

    source
    fn Expr::name(self : Expr) -> String

    Expr::named_selects

    source
    fn Expr::named_selects(self : Expr) -> Array[String]

    Selectable.named_selects: output names of the projections.

    Expr::neg

    source
    fn Expr::neg(self : Expr) -> Expr

    Python -expr (Expr.__neg__).

    Expr::neq

    source
    fn[T : IntoPy] Expr::neq(self : Expr, other : T) -> Expr raise SqlglotError

    Expr.neq(other)

    Expr::new

    source
    fn Expr::new(kind : Kind, args : Map[String, Value]) -> Expr

    Creates a new expression of kind with the given arguments. None arguments are skipped.

    Expr::not_

    source
    fn Expr::not_(self : Expr, copy? : Bool) -> Expr raise SqlglotError

    Expr.not_()

    Expr::offset_

    source
    fn[T : IntoPy] Expr::offset_(self : Expr, expression : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.offset(expression)

    Expr::on

    source
    fn[T : IntoPy] Expr::on(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Join.on(*expressions)

    Expr::or_

    source
    fn[T : IntoPy] Expr::or_(self : Expr, expressions : Array[T], dialect? : Dialect, copy? : Bool, wrap? : Bool) -> Expr raise SqlglotError

    Expr.or_(*expressions)

    Expr::order_by

    source
    fn[T : IntoPy] Expr::order_by(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.order_by(*expressions)

    Expr::output_name

    source
    fn Expr::output_name(self : Expr) -> String

    Name of the output column if this expression is a selection.

    Expr::parent_select

    source
    fn Expr::parent_select(self : Expr) -> Expr?

    Expr::parts

    source
    fn Expr::parts(self : Expr) -> Array[Expr]

    Table.parts / Dot.parts / Column.parts.

    Expr::pipe

    source
    fn[R] Expr::pipe(self : Expr, func : (Expr) -> R raise?) -> R raise?

    Expr.pipe(func): applies func to this expression and returns the result.

    Expr::pop

    source
    fn Expr::pop(self : Expr) -> Expr

    Removes this expression from its parent.

    Expr::pop_comments

    source
    fn Expr::pop_comments(self : Expr) -> Array[String]

    Expr::pow

    source
    fn[T : IntoPy] Expr::pow(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr ** other (Expr.__pow__).

    Expr::qualify

    source
    fn[T : IntoPy] Expr::qualify(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.qualify(*expressions)

    Expr::raw_list

    source
    fn Expr::raw_list(self : Expr, key : String) -> Array[Value]

    Returns the raw list argument key.

    Expr::replace

    source
    fn Expr::replace(self : Expr, expression : Expr?) -> Expr?

    Replaces this node with expression in its parent. Returns the new expression.

    Expr::replace_with_list

    source
    fn Expr::replace_with_list(self : Expr, expressions : Array[Expr]) -> Unit

    Replace with a list of expressions (Python replace([...])).

    Expr::returning

    source
    fn[T : IntoPy] Expr::returning(self : Expr, expression : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    DML.returning(expression)

    Expr::rlike

    source
    fn[T : IntoPy] Expr::rlike(self : Expr, other : T) -> Expr raise SqlglotError

    Expr.rlike(other)

    Expr::root

    source
    fn Expr::root(self : Expr) -> Expr

    Expr::same_parent

    source
    fn Expr::same_parent(self : Expr) -> Bool

    Expr::select_

    source
    fn[T : IntoPy] Expr::select_(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.select(*expressions, append=...) (also SetOperation.select and Subquery.select).

    Expr::selects

    source
    fn Expr::selects(self : Expr) -> Array[Expr]

    Selectable.selects: the projections of a query-like expression.

    Expr::set

    source
    fn Expr::set(self : Expr, arg_key : String, value : &IntoValue) -> Unit

    Sets arg_key to value. None removes the argument.

    Expr::set_

    source
    fn[T : IntoPy] Expr::set_(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Update.set_(*expressions)

    Expr::set_at

    source
    fn Expr::set_at(self : Expr, arg_key : String, value : &IntoValue, index : Int, overwrite? : Bool) -> Unit

    Expr.set(arg_key, value, index, overwrite) for list arguments.

    Expr::set_kwargs

    source
    fn Expr::set_kwargs(self : Expr, kwargs : ArrayView[(String, &IntoValue)]) -> Expr

    Expr::set_parent_ref

    source
    fn Expr::set_parent_ref(self : Expr, parent : Expr?) -> Unit

    Sets the parent pointer without attaching the node to parent's args (Python node.parent = parent).

    Expr::set_type

    source
    fn Expr::set_type(self : Expr, dtype : Expr?) -> Unit

    Sets the inferred data type of this expression.

    Expr::sort_by

    source
    fn[T : IntoPy] Expr::sort_by(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.sort_by(*expressions)

    Expr::str_arg

    source
    fn Expr::str_arg(self : Expr, key : String) -> String?

    Returns the string argument key, if it is a string.

    Expr::sub

    source
    fn[T : IntoPy] Expr::sub(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr - other (Expr.__sub__).

    Expr::subquery

    source
    fn Expr::subquery(self : Expr, alias? : String, copy? : Bool) -> Expr

    Query.subquery(alias, copy)

    Expr::table

    source
    fn[T : IntoPy] Expr::table(self : Expr, expression : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Update.table(expression): sets the table to update.

    Expr::table_name

    source
    fn Expr::table_name(self : Expr) -> String

    Expr::text

    source
    fn Expr::text(self : Expr, key : String) -> String

    Returns a textual representation of the argument corresponding to key.

    Expr::this

    source
    fn Expr::this(self : Expr) -> Expr?

    self.this when it is an expression.

    Expr::this_

    source
    fn Expr::this_(self : Expr) -> Expr

    self.this expression; panics if missing.

    Expr::to_column

    source
    fn Expr::to_column(self : Expr, copy? : Bool) -> Expr

    Table.to_column()

    Expr::to_dot

    source
    fn Expr::to_dot(self : Expr, include_dots? : Bool) -> Expr

    Column.to_dot(): converts the column into a dot expression.

    Expr::to_py

    source
    fn Expr::to_py(self : Expr) -> PyObj raise SqlglotError

    Python Expr.to_py(): returns a host value equivalent of the SQL node. Raises ValueError for nodes that can't be converted.

    Expr::to_py_float

    source
    fn Expr::to_py_float(self : Expr) -> Double?

    Converts a number literal to a Double.

    Expr::to_py_int

    source
    fn Expr::to_py_int(self : Expr) -> Int64?

    Converts a number literal to a host value: Int64 when integral.

    Expr::to_s

    source
    fn Expr::to_s(self : Expr) -> String

    Python Expr.__repr__ (_to_s): a textual representation of the expression tree.

    Expr::transform

    source
    fn Expr::transform(self : Expr, fun : (Expr) -> Expr? raise?, copy? : Bool) -> Expr raise?

    Recursively visits all tree nodes (DFS) and applies fun to each, replacing nodes.

    Expr::transform_values

    source
    fn Expr::transform_values(self : Expr, fun : (Expr) -> Value? raise?, copy? : Bool) -> Value raise?

    Python Expr.transform(fun) where fun may return a node, a list of nodes or None (Python's transform accepts any of these as replacement values).

    Expr::truediv

    source
    fn[T : IntoPy] Expr::truediv(self : Expr, other : T) -> Expr raise SqlglotError

    Python expr / other (Expr.__truediv__).

    Expr::unalias

    source
    fn Expr::unalias(self : Expr) -> Expr

    Expr::union_

    source
    fn[T : IntoPy] Expr::union_(self : Expr, other : T, distinct? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.union(*expressions, distinct=...)

    Expr::unnest

    source
    fn Expr::unnest(self : Expr) -> Expr

    Returns the first non-parenthesis child (or first non-subquery for subqueries).

    Expr::unnest_operands

    source
    fn Expr::unnest_operands(self : Expr) -> Array[Expr]

    Expr::unwrap_subquery

    source
    fn Expr::unwrap_subquery(self : Expr) -> Expr

    Subquery.unwrap

    Expr::update_positions

    source
    fn Expr::update_positions(self : Expr, other : Expr?) -> Expr

    Expr::update_positions_from_token

    source
    fn Expr::update_positions_from_token(self : Expr, token : Token) -> Expr

    Updates position meta from a token.

    Expr::using_

    source
    fn[T : IntoPy] Expr::using_(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Join.using(*expressions)

    Expr::walk

    source
    fn Expr::walk(self : Expr, bfs? : Bool, prune? : (Expr) -> Bool) -> Iter[Expr]

    Expr::when_

    source
    fn[C : IntoPy, T : IntoPy] Expr::when_(self : Expr, condition : C, then : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Case.when(condition, then)

    Expr::where_

    source
    fn[T : IntoPy] Expr::where_(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Query.where(*expressions) (also Delete.where / Update.where)

    Expr::window

    source
    fn[T : IntoPy] Expr::window(self : Expr, expressions : Array[T], append? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Select.window(*expressions)

    Expr::with_

    source
    fn[A : IntoPy, B : IntoPy] Expr::with_(self : Expr, alias : A, as_ : B, recursive? : Bool, materialized? : Bool, append? : Bool, dialect? : Dialect, copy? : Bool, scalar? : Bool) -> Expr raise SqlglotError

    Query.with_(alias, as_, recursive=...) (also Insert.with_ / Update.with_)

    Generator

    source
    pub(all) struct Generator {
      dialect : Dialect
      cfg : GeneratorConfig
      fns : GeneratorFns
      pretty : Bool
      identify : String
      normalize : Bool
      pad : Int
      indent_size : Int
      normalize_functions : String
      unsupported_level : ErrorLevel
      max_unsupported : Int
      leading_comma : Bool
      max_text_width : Int
      comments : Bool
      unsupported_messages : Array[String]
      escaped_quote_end : String
      escaped_byte_quote_end : String
      escaped_identifier_end : String
      next_name : () -> String
      identifier_start : String
      identifier_end : String
      quote_json_path_key_using_brackets : Bool
    }

    Converts a given syntax tree to the corresponding SQL string.

    Generator::add_arrayagg_null_filter

    source
    fn Generator::add_arrayagg_null_filter(self : Generator, array_agg_sql : String, array_agg_expr : Expr, column_expr : Expr?) -> String raise SqlglotError

    Python _add_arrayagg_null_filter.

    Generator::add_column_sql

    source
    fn Generator::add_column_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Virtual add_column_sql.

    Generator::add_column_sql_base

    source
    fn Generator::add_column_sql_base(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::add_sql

    source
    fn Generator::add_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::addconstraint_sql

    source
    fn Generator::addconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::addpartition_sql

    source
    fn Generator::addpartition_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::after_limit_modifiers

    source
    fn Generator::after_limit_modifiers(self : Generator, expression : Expr) -> Array[String] raise SqlglotError

    Virtual after_limit_modifiers.

    Generator::after_limit_modifiers_base

    source
    fn Generator::after_limit_modifiers_base(self : Generator, expression : Expr) -> Array[String] raise SqlglotError

    Generator::aiforecast_sql

    source
    fn Generator::aiforecast_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::alias_sql

    source
    fn Generator::alias_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::aliases_sql

    source
    fn Generator::aliases_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::all_sql

    source
    fn Generator::all_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::alter_column_null_constraint_sql

    source
    fn Generator::alter_column_null_constraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Python _alter_column_null_constraint_sql.

    Generator::alter_sql

    source
    fn Generator::alter_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::altercolumn_sql

    source
    fn Generator::altercolumn_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::alterdiststyle_sql

    source
    fn Generator::alterdiststyle_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::alterindex_sql

    source
    fn Generator::alterindex_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::altermodifysqlsecurity_sql

    source
    fn Generator::altermodifysqlsecurity_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::alterrename_sql

    source
    fn Generator::alterrename_sql(self : Generator, expression : Expr, include_to? : Bool) -> String raise SqlglotError

    Generator::alterrename_sql_v

    source
    fn Generator::alterrename_sql_v(self : Generator, expression : Expr, include_to? : Bool) -> String raise SqlglotError

    Virtual alterrename_sql(expression, include_to).

    Generator::altersession_sql

    source
    fn Generator::altersession_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::alterset_sql

    source
    fn Generator::alterset_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::altersortkey_sql

    source
    fn Generator::altersortkey_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyze_sql

    source
    fn Generator::analyze_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyzedelete_sql

    source
    fn Generator::analyzedelete_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyzehistogram_sql

    source
    fn Generator::analyzehistogram_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyzelistchainedrows_sql

    source
    fn Generator::analyzelistchainedrows_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyzesample_sql

    source
    fn Generator::analyzesample_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyzestatistics_sql

    source
    fn Generator::analyzestatistics_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::analyzevalidate_sql

    source
    fn Generator::analyzevalidate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::and_sql

    source
    fn Generator::and_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::anonymous_sql

    source
    fn Generator::anonymous_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::anonymousaggfunc_sql

    source
    fn Generator::anonymousaggfunc_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::any_sql

    source
    fn Generator::any_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::anyvalue_sql

    source
    fn Generator::anyvalue_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::apply_sql

    source
    fn Generator::apply_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::arrayagg_sql

    source
    fn Generator::arrayagg_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::arrayany_sql

    source
    fn Generator::arrayany_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::arrayinsert_sql

    source
    fn Generator::arrayinsert_sql(self : Generator, expression : Expr, index_offset? : Int) -> String raise SqlglotError

    Generator::arrayinsert_sql_v

    source
    fn Generator::arrayinsert_sql_v(self : Generator, expression : Expr, index_offset? : Int) -> String raise SqlglotError

    Virtual arrayinsert_sql(expression, index_offset).

    Generator::arraysize_sql

    source
    fn Generator::arraysize_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::atindex_sql

    source
    fn Generator::atindex_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::attach_sql

    source
    fn Generator::attach_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::attachoption_sql

    source
    fn Generator::attachoption_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::attimezone_sql

    source
    fn Generator::attimezone_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::autoincrementcolumnconstraint_sql

    source
    fn Generator::autoincrementcolumnconstraint_sql(self : Generator, expression : Expr) -> String

    Generator::base_dispatch

    source
    fn Generator::base_dispatch(self : Generator, kind : Kind, e : Expr) -> String? raise SqlglotError

    The base Generator's <key>_sql method for kind, if any (Python _build_dispatch minus TRANSFORMS).

    Generator::between_sql

    source
    fn Generator::between_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::binary

    source
    fn Generator::binary(self : Generator, expression : Expr, op : String) -> String raise SqlglotError

    Generator::bitstring_sql

    source
    fn Generator::bitstring_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bitwiseand_sql

    source
    fn Generator::bitwiseand_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bitwiseleftshift_sql

    source
    fn Generator::bitwiseleftshift_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bitwisenot_sql

    source
    fn Generator::bitwisenot_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bitwiseor_sql

    source
    fn Generator::bitwiseor_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bitwiserightshift_sql

    source
    fn Generator::bitwiserightshift_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bitwisexor_sql

    source
    fn Generator::bitwisexor_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::block_sql

    source
    fn Generator::block_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::blockcompressionproperty_sql

    source
    fn Generator::blockcompressionproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::booland_sql

    source
    fn Generator::booland_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::boolean_sql

    source
    fn Generator::boolean_sql(self : Generator, expression : Expr) -> String

    Generator::boolor_sql

    source
    fn Generator::boolor_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bracket_offset_expressions

    source
    fn Generator::bracket_offset_expressions(self : Generator, expression : Expr, index_offset? : Int) -> Array[Expr] raise SqlglotError

    Generator::bracket_sql

    source
    fn Generator::bracket_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::buildproperty_sql

    source
    fn Generator::buildproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::bytestring_sql

    source
    fn Generator::bytestring_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::cache_sql

    source
    fn Generator::cache_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::call_method

    source
    fn Generator::call_method(self : Generator, kind : Kind, expression : Expr) -> String raise SqlglotError

    Virtual call of a <key>_sql method: a dialect override if present, else the base implementation (Python self.<key>_sql(expression)).

    Generator::case_sql

    source
    fn Generator::case_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::casestatement_sql

    source
    fn Generator::casestatement_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::cast_sql

    source
    fn Generator::cast_sql(self : Generator, expression : Expr, safe_prefix? : String) -> String raise SqlglotError

    Generator::cast_sql_v

    source
    fn Generator::cast_sql_v(self : Generator, expression : Expr, safe_prefix? : String) -> String raise SqlglotError

    Virtual cast_sql(expression, safe_prefix).

    Generator::ceil_floor

    source
    fn Generator::ceil_floor(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::changes_sql

    source
    fn Generator::changes_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::characterset_sql

    source
    fn Generator::characterset_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::check_sql

    source
    fn Generator::check_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::checkcolumnconstraint_sql

    source
    fn Generator::checkcolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::checksumproperty_sql

    source
    fn Generator::checksumproperty_sql(self : Generator, expression : Expr) -> String

    Generator::chr_sql

    source
    fn Generator::chr_sql(self : Generator, expression : Expr, name? : String) -> String raise SqlglotError

    Generator::chr_sql_v

    source
    fn Generator::chr_sql_v(self : Generator, expression : Expr, name? : String) -> String raise SqlglotError

    Virtual chr_sql(expression, name).

    Generator::clone_sql

    source
    fn Generator::clone_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::cluster_sql

    source
    fn Generator::cluster_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::clusteredbyproperty_sql

    source
    fn Generator::clusteredbyproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::clusterproperty_sql

    source
    fn Generator::clusterproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::collate_sql

    source
    fn Generator::collate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::column_parts

    source
    fn Generator::column_parts(self : Generator, expression : Expr) -> String raise SqlglotError

    Virtual column_parts.

    Generator::column_parts_base

    source
    fn Generator::column_parts_base(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::column_sql

    source
    fn Generator::column_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::columnconstraint_sql

    source
    fn Generator::columnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::columndef_sql

    source
    fn Generator::columndef_sql(self : Generator, expression : Expr, sep? : String) -> String raise SqlglotError

    Generator::columndef_sql_v

    source
    fn Generator::columndef_sql_v(self : Generator, expression : Expr, sep? : String) -> String raise SqlglotError

    Virtual columndef_sql(expression, sep).

    Generator::columnposition_sql

    source
    fn Generator::columnposition_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::columnprefix_sql

    source
    fn Generator::columnprefix_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::columns_sql

    source
    fn Generator::columns_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::combinedaggfunc_sql

    source
    fn Generator::combinedaggfunc_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::combinedparameterizedagg_sql

    source
    fn Generator::combinedparameterizedagg_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::command_sql

    source
    fn Generator::command_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::comment_sql

    source
    fn Generator::comment_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::commit_sql

    source
    fn Generator::commit_sql(self : Generator, expression : Expr) -> String

    Generator::comprehension_sql

    source
    fn Generator::comprehension_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::compresscolumnconstraint_sql

    source
    fn Generator::compresscolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::computedcolumnconstraint_sql

    source
    fn Generator::computedcolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::concat_sql

    source
    fn Generator::concat_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::concat_to_dpipe_sql

    source
    fn Generator::concat_to_dpipe_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Python dialects.dialect.concat_to_dpipe_sql.

    Generator::concatws_sql

    source
    fn Generator::concatws_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::conditionalinsert_sql

    source
    fn Generator::conditionalinsert_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::connect_sql

    source
    fn Generator::connect_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::connector_sql

    source
    fn Generator::connector_sql(self : Generator, expression : Expr, op : String) -> String raise SqlglotError

    Generator::constraint_sql

    source
    fn Generator::constraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::convert_concat_args

    source
    fn Generator::convert_concat_args(self : Generator, expression : Expr) -> Array[Expr] raise SqlglotError

    Generator::convert_sql

    source
    fn Generator::convert_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::converttimezone_sql

    source
    fn Generator::converttimezone_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::copy_sql

    source
    fn Generator::copy_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::copyparameter_sql

    source
    fn Generator::copyparameter_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::create_sql

    source
    fn Generator::create_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::createable_sql

    source
    fn Generator::createable_sql(self : Generator, expression : Expr, locations : Map[PropertiesLocation, Array[Expr]]) -> String raise SqlglotError

    Virtual createable_sql.

    Generator::createable_sql_base

    source
    fn Generator::createable_sql_base(self : Generator, expression : Expr, locations : Map[PropertiesLocation, Array[Expr]]) -> String raise SqlglotError

    Generator::credentials_sql

    source
    fn Generator::credentials_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::cte_sql

    source
    fn Generator::cte_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::cube_sql

    source
    fn Generator::cube_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::currentdate_sql

    source
    fn Generator::currentdate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::datablocksizeproperty_sql

    source
    fn Generator::datablocksizeproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::datadeletionproperty_sql

    source
    fn Generator::datadeletionproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::datatype_param_bound_limiter

    source
    fn Generator::datatype_param_bound_limiter(self : Generator, expression : Expr, type_value : DType, defaults : Array[Int], bounds : Array[Int?]) -> Expr raise SqlglotError

    Generator::datatype_sql

    source
    fn Generator::datatype_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::datatypeparam_sql

    source
    fn Generator::datatypeparam_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dateadd_sql

    source
    fn Generator::dateadd_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::datefromunixdate_sql

    source
    fn Generator::datefromunixdate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::declare_sql

    source
    fn Generator::declare_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::declareitem_sql

    source
    fn Generator::declareitem_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::decodecase_sql

    source
    fn Generator::decodecase_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::delete_sql

    source
    fn Generator::delete_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::describe_sql

    source
    fn Generator::describe_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::detach_sql

    source
    fn Generator::detach_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dialect_class_name

    source
    fn Generator::dialect_class_name(self : Generator) -> String

    The dialect's class name, used in some messages (Python self.dialect.__class__.__name__).

    Generator::dictproperty_sql

    source
    fn Generator::dictproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dictrange_sql

    source
    fn Generator::dictrange_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dictsubproperty_sql

    source
    fn Generator::dictsubproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::directory_sql

    source
    fn Generator::directory_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::directorystage_sql

    source
    fn Generator::directorystage_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::distance_sql

    source
    fn Generator::distance_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::distancend_sql

    source
    fn Generator::distancend_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::distinct_sql

    source
    fn Generator::distinct_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::distribute_sql

    source
    fn Generator::distribute_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::distributedbyproperty_sql

    source
    fn Generator::distributedbyproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::div_sql

    source
    fn Generator::div_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dot_sql

    source
    fn Generator::dot_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dpipe_sql

    source
    fn Generator::dpipe_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::drop_sql

    source
    fn Generator::drop_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::droppartition_sql

    source
    fn Generator::droppartition_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dropprimarykey_sql

    source
    fn Generator::dropprimarykey_sql(self : Generator, expression : Expr) -> String

    Generator::duplicatekeyproperty_sql

    source
    fn Generator::duplicatekeyproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::dynamicidentifier_sql

    source
    fn Generator::dynamicidentifier_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::embed_ignore_nulls

    source
    fn Generator::embed_ignore_nulls(self : Generator, expression : Expr, text : String) -> String raise SqlglotError

    Python _embed_ignore_nulls.

    Generator::encodeproperty_sql

    source
    fn Generator::encodeproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::eq_sql

    source
    fn Generator::eq_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::escape_sql

    source
    fn Generator::escape_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::escape_str

    source
    fn Generator::escape_str(self : Generator, text : String, escape_backslash? : Bool, delimiter? : String, escaped_delimiter? : String, is_byte_string? : Bool) -> String

    Generator::execute_sql

    source
    fn Generator::execute_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::executesql_sql

    source
    fn Generator::executesql_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::exists_sql

    source
    fn Generator::exists_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::explodinggenerateseries_sql

    source
    fn Generator::explodinggenerateseries_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::export_sql

    source
    fn Generator::export_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::expressions

    source
    fn Generator::expressions(self : Generator, expression? : Expr, key? : String, sqls? : Array[Value], flat? : Bool, indent? : Bool, skip_first? : Bool, skip_last? : Bool, sep? : String, prefix? : String, dynamic? : Bool, new_line? : Bool) -> String raise SqlglotError

    Python self.expressions(...).

    Generator::extract_sql

    source
    fn Generator::extract_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::fallbackproperty_sql

    source
    fn Generator::fallbackproperty_sql(self : Generator, expression : Expr) -> String

    Generator::featuresattime_sql

    source
    fn Generator::featuresattime_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::fetch_sql

    source
    fn Generator::fetch_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::filter_sql

    source
    fn Generator::filter_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::forclause_sql

    source
    fn Generator::forclause_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::foreignkey_sql

    source
    fn Generator::foreignkey_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::forin_sql

    source
    fn Generator::forin_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::format_args

    source
    fn Generator::format_args(self : Generator, args : Array[&SqlArg], sep? : String) -> String raise SqlglotError

    Generator::format_time

    source
    fn Generator::format_time(self : Generator, expression : Expr, inverse_time_mapping? : Map[String, String], inverse_time_trie? : Trie) -> String? raise SqlglotError

    Virtual format_time.

    Generator::format_time_base

    source
    fn Generator::format_time_base(self : Generator, expression : Expr, inverse_time_mapping? : Map[String, String], inverse_time_trie? : Trie) -> String? raise SqlglotError

    Generator::formatjson_sql

    source
    fn Generator::formatjson_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::formatphrase_sql

    source
    fn Generator::formatphrase_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::freespaceproperty_sql

    source
    fn Generator::freespaceproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::from_sql

    source
    fn Generator::from_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::fromiso8601date_sql

    source
    fn Generator::fromiso8601date_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::fromiso8601timestamp_sql

    source
    fn Generator::fromiso8601timestamp_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::fromiso8601timestampnanos_sql

    source
    fn Generator::fromiso8601timestampnanos_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::fromtimezone_sql

    source
    fn Generator::fromtimezone_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::func

    source
    fn Generator::func(self : Generator, name : String, args : Array[&SqlArg], prefix? : String, suffix? : String, normalize? : Bool) -> String raise SqlglotError

    Generator::function_fallback_sql

    source
    fn Generator::function_fallback_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::functionspecification_sql

    source
    fn Generator::functionspecification_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::gapfill_sql

    source
    fn Generator::gapfill_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generate

    source
    fn Generator::generate(self : Generator, expression : Expr, copy? : Bool) -> String raise SqlglotError

    Generates the SQL string corresponding to the given syntax tree (virtual).

    Generator::generate_base

    source
    fn Generator::generate_base(self : Generator, expression : Expr, copy? : Bool) -> String raise SqlglotError

    Generator::generatebool_sql

    source
    fn Generator::generatebool_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generatedasidentitycolumnconstraint_sql

    source
    fn Generator::generatedasidentitycolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generatedasrowcolumnconstraint_sql

    source
    fn Generator::generatedasrowcolumnconstraint_sql(self : Generator, expression : Expr) -> String

    Generator::generatedouble_sql

    source
    fn Generator::generatedouble_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generateembedding_sql

    source
    fn Generator::generateembedding_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generateint_sql

    source
    fn Generator::generateint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generatetable_sql

    source
    fn Generator::generatetable_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::generatetext_sql

    source
    fn Generator::generatetext_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::get_put_sql

    source
    fn Generator::get_put_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::getextract_sql

    source
    fn Generator::getextract_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::glob_sql

    source
    fn Generator::glob_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::grant_or_revoke_sql

    source
    fn Generator::grant_or_revoke_sql(self : Generator, expression : Expr, keyword~ : String, preposition~ : String, grant_option_prefix? : String, grant_option_suffix? : String) -> String raise SqlglotError

    Python _grant_or_revoke_sql.

    Generator::grant_sql

    source
    fn Generator::grant_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::grantprincipal_sql

    source
    fn Generator::grantprincipal_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::grantprivilege_sql

    source
    fn Generator::grantprivilege_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::group_sql

    source
    fn Generator::group_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::groupingsets_sql

    source
    fn Generator::groupingsets_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::gt_sql

    source
    fn Generator::gt_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::gte_sql

    source
    fn Generator::gte_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::having_sql

    source
    fn Generator::having_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::havingmax_sql

    source
    fn Generator::havingmax_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::heredoc_sql

    source
    fn Generator::heredoc_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::hex_sql

    source
    fn Generator::hex_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::hexstring_sql

    source
    fn Generator::hexstring_sql(self : Generator, expression : Expr, binary_function_repr? : String) -> String raise SqlglotError

    Generator::hexstring_sql_v

    source
    fn Generator::hexstring_sql_v(self : Generator, expression : Expr, binary_function_repr? : String) -> String raise SqlglotError

    Virtual hexstring_sql(expression, binary_function_repr).

    Generator::hint_sql

    source
    fn Generator::hint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::historicaldata_sql

    source
    fn Generator::historicaldata_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::identifier_sql

    source
    fn Generator::identifier_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::if_sql

    source
    fn Generator::if_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::ifblock_sql

    source
    fn Generator::ifblock_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::ignorenulls_sql

    source
    fn Generator::ignorenulls_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::ilike_sql

    source
    fn Generator::ilike_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::in_sql

    source
    fn Generator::in_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::in_unnest_op

    source
    fn Generator::in_unnest_op(self : Generator, unnest : Expr) -> String raise SqlglotError

    Virtual in_unnest_op.

    Generator::in_unnest_op_base

    source
    fn Generator::in_unnest_op_base(self : Generator, unnest : Expr) -> String raise SqlglotError

    Generator::includeproperty_sql

    source
    fn Generator::includeproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::indent

    source
    fn Generator::indent(self : Generator, sql : String, level? : Int, pad? : Int, skip_first? : Bool, skip_last? : Bool) -> String

    Generator::index_sql

    source
    fn Generator::index_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::indexcolumnconstraint_sql

    source
    fn Generator::indexcolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::indexconstraintoption_sql

    source
    fn Generator::indexconstraintoption_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::indexparameters_sql

    source
    fn Generator::indexparameters_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::indextablehint_sql

    source
    fn Generator::indextablehint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::initcap_sql

    source
    fn Generator::initcap_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::inoutcolumnconstraint_sql

    source
    fn Generator::inoutcolumnconstraint_sql(self : Generator, expression : Expr) -> String

    Generator::inputoutputformat_sql

    source
    fn Generator::inputoutputformat_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::insert_sql

    source
    fn Generator::insert_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::install_sql

    source
    fn Generator::install_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::intdiv_sql

    source
    fn Generator::intdiv_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::interval_sql

    source
    fn Generator::interval_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::into_sql

    source
    fn Generator::into_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::introducer_sql

    source
    fn Generator::introducer_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::is_sql

    source
    fn Generator::is_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::isolatedloadingproperty_sql

    source
    fn Generator::isolatedloadingproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::iterate_sql

    source
    fn Generator::iterate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::join_sql

    source
    fn Generator::join_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::joinhint_sql

    source
    fn Generator::joinhint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::journalproperty_sql

    source
    fn Generator::journalproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::json_path_part

    source
    fn Generator::json_path_part(self : Generator, expression : Value?) -> String raise SqlglotError

    Generator::json_sql

    source
    fn Generator::json_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonarray_sql

    source
    fn Generator::jsonarray_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonarrayagg_sql

    source
    fn Generator::jsonarrayagg_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsoncast_sql

    source
    fn Generator::jsoncast_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsoncolumndef_sql

    source
    fn Generator::jsoncolumndef_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonexists_sql

    source
    fn Generator::jsonexists_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonextractquote_sql

    source
    fn Generator::jsonextractquote_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonkeyvalue_sql

    source
    fn Generator::jsonkeyvalue_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonobject_sql

    source
    fn Generator::jsonobject_sql(self : Generator, expression : Expr, name? : String) -> String raise SqlglotError

    Python _jsonobject_sql(expression, name).

    Generator::jsonpath_sql

    source
    fn Generator::jsonpath_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonpathkey_sql

    source
    fn Generator::jsonpathkey_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Python _jsonpathkey_sql.

    Generator::jsonpathsubscript_sql

    source
    fn Generator::jsonpathsubscript_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Python _jsonpathsubscript_sql.

    Generator::jsonschema_sql

    source
    fn Generator::jsonschema_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsontable_sql

    source
    fn Generator::jsontable_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::jsonvalue_sql

    source
    fn Generator::jsonvalue_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::kill_sql

    source
    fn Generator::kill_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::kwarg_sql

    source
    fn Generator::kwarg_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::lambda_sql

    source
    fn Generator::lambda_sql(self : Generator, expression : Expr, arrow_sep? : String, wrap? : Bool) -> String raise SqlglotError

    Generator::lambda_sql_v

    source
    fn Generator::lambda_sql_v(self : Generator, expression : Expr, arrow_sep? : String, wrap? : Bool) -> String raise SqlglotError

    Generator::lastday_sql

    source
    fn Generator::lastday_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::lateral_op

    source
    fn Generator::lateral_op(self : Generator, expression : Expr) -> String raise SqlglotError

    Virtual lateral_op.

    Generator::lateral_op_base

    source
    fn Generator::lateral_op_base(self : Generator, expression : Expr) -> String

    Generator::lateral_sql

    source
    fn Generator::lateral_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::leave_sql

    source
    fn Generator::leave_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::like_sql

    source
    fn Generator::like_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::like_sql_inner

    source
    fn Generator::like_sql_inner(self : Generator, expression : Expr, escape? : Expr) -> String raise SqlglotError

    Python _like_sql(expression, escape).

    Generator::likeproperty_sql

    source
    fn Generator::likeproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::limit_sql

    source
    fn Generator::limit_sql(self : Generator, expression : Expr, top? : Bool) -> String raise SqlglotError

    Generator::limitoptions_sql

    source
    fn Generator::limitoptions_sql(self : Generator, expression : Expr) -> String

    Generator::literal_sql

    source
    fn Generator::literal_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::loaddata_sql

    source
    fn Generator::loaddata_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::localtime_sql

    source
    fn Generator::localtime_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::localtimestamp_sql

    source
    fn Generator::localtimestamp_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::locate_properties

    source
    fn Generator::locate_properties(self : Generator, properties : Expr) -> Map[PropertiesLocation, Array[Expr]] raise SqlglotError

    Virtual locate_properties.

    Generator::locate_properties_base

    source
    fn Generator::locate_properties_base(self : Generator, properties : Expr) -> Map[PropertiesLocation, Array[Expr]] raise SqlglotError

    Generator::lock_sql

    source
    fn Generator::lock_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::lockingproperty_sql

    source
    fn Generator::lockingproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::log_sql

    source
    fn Generator::log_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::loopblock_sql

    source
    fn Generator::loopblock_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::lowerhex_sql

    source
    fn Generator::lowerhex_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::lt_sql

    source
    fn Generator::lt_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::lte_sql

    source
    fn Generator::lte_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::macrooverload_sql

    source
    fn Generator::macrooverload_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::macrooverloads_sql

    source
    fn Generator::macrooverloads_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::maskingpolicycolumnconstraint_sql

    source
    fn Generator::maskingpolicycolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::match_sql

    source
    fn Generator::match_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::matchagainst_sql

    source
    fn Generator::matchagainst_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::matchrecognize_sql

    source
    fn Generator::matchrecognize_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::matchrecognizemeasure_sql

    source
    fn Generator::matchrecognizemeasure_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::maybe_comment

    source
    fn Generator::maybe_comment(self : Generator, sql : String, expression? : Expr, comments? : Array[String], separated? : Bool) -> String

    Generator::median_sql

    source
    fn Generator::median_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::merge_sql

    source
    fn Generator::merge_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::mergeblockratioproperty_sql

    source
    fn Generator::mergeblockratioproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::mergetreettl_sql

    source
    fn Generator::mergetreettl_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::mergetreettlaction_sql

    source
    fn Generator::mergetreettlaction_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::ml_sql

    source
    fn Generator::ml_sql(self : Generator, expression : Expr, name : String) -> String raise SqlglotError

    Python _ml_sql(expression, name).

    Generator::mlforecast_sql

    source
    fn Generator::mlforecast_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::mltranslate_sql

    source
    fn Generator::mltranslate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::mod_sql

    source
    fn Generator::mod_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::modelattribute_sql

    source
    fn Generator::modelattribute_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::modifycolumn_sql

    source
    fn Generator::modifycolumn_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::moduleproperty_sql

    source
    fn Generator::moduleproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::move_ctes_to_top_level

    source
    fn Generator::move_ctes_to_top_level(self : Generator, expression : Expr) -> Expr

    Python _move_ctes_to_top_level.

    Generator::mul_sql

    source
    fn Generator::mul_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::multitableinserts_sql

    source
    fn Generator::multitableinserts_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::naked_property

    source
    fn Generator::naked_property(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::national_sql

    source
    fn Generator::national_sql(self : Generator, expression : Expr, prefix? : String) -> String raise SqlglotError

    Generator::neg_sql

    source
    fn Generator::neg_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::neq_sql

    source
    fn Generator::neq_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::new

    source
    fn Generator::new(dialect : Dialect, pretty? : Bool, identify? : String, normalize? : Bool, pad? : Int, indent? : Int, normalize_functions? : String, unsupported_level? : ErrorLevel, max_unsupported? : Int, leading_comma? : Bool, max_text_width? : Int, comments? : Bool) -> Generator

    Generator::nextvaluefor_sql

    source
    fn Generator::nextvaluefor_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::no_identify

    source
    fn[T] Generator::no_identify(self : Generator, f : () -> T raise SqlglotError) -> T raise SqlglotError

    Runs f with identify disabled.

    Generator::normalize_func

    source
    fn Generator::normalize_func(self : Generator, name : String) -> String

    Generator::not_sql

    source
    fn Generator::not_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::notnullcolumnconstraint_sql

    source
    fn Generator::notnullcolumnconstraint_sql(self : Generator, expression : Expr) -> String

    Generator::nthvalue_sql

    source
    fn Generator::nthvalue_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::null_sql

    source
    fn Generator::null_sql(self : Generator, expression : Expr) -> String

    Generator::nullsafeeq_sql

    source
    fn Generator::nullsafeeq_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::nullsafeneq_sql

    source
    fn Generator::nullsafeneq_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::nvl2_sql

    source
    fn Generator::nvl2_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::objectidentifier_sql

    source
    fn Generator::objectidentifier_sql(self : Generator, expression : Expr) -> String

    Generator::offset_limit_modifiers

    source
    fn Generator::offset_limit_modifiers(self : Generator, expression : Expr, fetch : Bool, limit : Expr?) -> Array[String] raise SqlglotError

    Virtual offset_limit_modifiers.

    Generator::offset_limit_modifiers_base

    source
    fn Generator::offset_limit_modifiers_base(self : Generator, expression : Expr, fetch : Bool, limit : Expr?) -> Array[String] raise SqlglotError

    Generator::offset_sql

    source
    fn Generator::offset_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::oncluster_sql

    source
    fn Generator::oncluster_sql(self : Generator, expression : Expr) -> String

    Generator::oncondition_sql

    source
    fn Generator::oncondition_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::onconflict_sql

    source
    fn Generator::onconflict_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::op_expressions

    source
    fn Generator::op_expressions(self : Generator, op : String, expression : Expr, flat? : Bool) -> String raise SqlglotError

    Generator::opclass_sql

    source
    fn Generator::opclass_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::openjson_sql

    source
    fn Generator::openjson_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::openjsoncolumndef_sql

    source
    fn Generator::openjsoncolumndef_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::options_modifier

    source
    fn Generator::options_modifier(self : Generator, expression : Expr) -> String raise SqlglotError

    Virtual options_modifier.

    Generator::options_modifier_base

    source
    fn Generator::options_modifier_base(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::or_sql

    source
    fn Generator::or_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::order_sql

    source
    fn Generator::order_sql(self : Generator, expression : Expr, flat? : Bool) -> String raise SqlglotError

    Generator::ordered_sql

    source
    fn Generator::ordered_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::overflowtruncatebehavior_sql

    source
    fn Generator::overflowtruncatebehavior_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::overlaps_sql

    source
    fn Generator::overlaps_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::overlay_sql

    source
    fn Generator::overlay_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::pad_sql

    source
    fn Generator::pad_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::parameter_sql

    source
    fn Generator::parameter_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::parameterizedagg_sql

    source
    fn Generator::parameterizedagg_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::paren_sql

    source
    fn Generator::paren_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::parsedatetime_sql

    source
    fn Generator::parsedatetime_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::parsejson_sql

    source
    fn Generator::parsejson_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partition_by_sql

    source
    fn Generator::partition_by_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partition_sql

    source
    fn Generator::partition_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partitionboundspec_sql

    source
    fn Generator::partitionboundspec_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partitionbyrangeproperty_sql

    source
    fn Generator::partitionbyrangeproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partitionbyrangepropertydynamic_sql

    source
    fn Generator::partitionbyrangepropertydynamic_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partitionedofproperty_sql

    source
    fn Generator::partitionedofproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::partitionrange_sql

    source
    fn Generator::partitionrange_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::periodforsystemtimeconstraint_sql

    source
    fn Generator::periodforsystemtimeconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::pivot_in_value_aliases

    source
    fn Generator::pivot_in_value_aliases(self : Generator, expression : Expr) -> Array[Expr]? raise SqlglotError

    Python _pivot_in_value_aliases.

    Generator::pivot_sql

    source
    fn Generator::pivot_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::pivotalias_sql

    source
    fn Generator::pivotalias_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::placeholder_sql

    source
    fn Generator::placeholder_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::pragma_sql

    source
    fn Generator::pragma_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::predict_sql

    source
    fn Generator::predict_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::prepend_ctes

    source
    fn Generator::prepend_ctes(self : Generator, expression : Expr, sql : String) -> String raise SqlglotError

    Generator::preprocess

    source
    fn Generator::preprocess(self : Generator, expression : Expr) -> Expr raise SqlglotError

    Apply generic preprocessing transformations to a given expression.

    Generator::preprocess_base

    source
    fn Generator::preprocess_base(self : Generator, expression : Expr) -> Expr raise SqlglotError

    Generator::prewhere_sql

    source
    fn Generator::prewhere_sql(self : Generator, expression : Expr) -> String

    Generator::primarykey_sql

    source
    fn Generator::primarykey_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::primarykeycolumnconstraint_sql

    source
    fn Generator::primarykeycolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::prior_sql

    source
    fn Generator::prior_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::properties

    source
    fn Generator::properties(self : Generator, properties : Expr, prefix? : String, sep? : String, suffix? : String, wrapped? : Bool) -> String raise SqlglotError

    Generator::properties_sql

    source
    fn Generator::properties_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::property_location

    source
    fn Generator::property_location(self : Generator, p : Expr) -> PropertiesLocation raise SqlglotError

    Generator::property_name

    source
    fn Generator::property_name(self : Generator, expression : Expr, string_key? : Bool) -> String raise SqlglotError

    Generator::property_sql

    source
    fn Generator::property_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::propertyeq_sql

    source
    fn Generator::propertyeq_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::pseudocolumn_sql

    source
    fn Generator::pseudocolumn_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::pseudotype_sql

    source
    fn Generator::pseudotype_sql(self : Generator, expression : Expr) -> String

    Generator::qualify_sql

    source
    fn Generator::qualify_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::query_modifiers

    source
    fn Generator::query_modifiers(self : Generator, expression : Expr, sqls : Array[String]) -> String raise SqlglotError

    Generator::queryband_sql

    source
    fn Generator::queryband_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::queryoption_sql

    source
    fn Generator::queryoption_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::querytransform_sql

    source
    fn Generator::querytransform_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::rand_sql

    source
    fn Generator::rand_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::rawstring_sql

    source
    fn Generator::rawstring_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::recursivewithsearch_sql

    source
    fn Generator::recursivewithsearch_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::reference_sql

    source
    fn Generator::reference_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::refresh_sql

    source
    fn Generator::refresh_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::refreshtriggerproperty_sql

    source
    fn Generator::refreshtriggerproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::renamecolumn_sql

    source
    fn Generator::renamecolumn_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::renameindex_sql

    source
    fn Generator::renameindex_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::repeatblock_sql

    source
    fn Generator::repeatblock_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::replace_line_breaks

    source
    fn Generator::replace_line_breaks(self : Generator, string : String) -> String

    Python _replace_line_breaks.

    Generator::resolve_ordered_for_null_ordering_simulation

    source
    fn Generator::resolve_ordered_for_null_ordering_simulation(self : Generator, expression : Expr) -> Expr?

    Python _resolve_ordered_for_null_ordering_simulation.

    Generator::respectnulls_sql

    source
    fn Generator::respectnulls_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::return_sql

    source
    fn Generator::return_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::returning_sql

    source
    fn Generator::returning_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::revoke_sql

    source
    fn Generator::revoke_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::rollback_sql

    source
    fn Generator::rollback_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::rollup_sql

    source
    fn Generator::rollup_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::rollupindex_sql

    source
    fn Generator::rollupindex_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::rollupproperty_sql

    source
    fn Generator::rollupproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::root_properties

    source
    fn Generator::root_properties(self : Generator, properties : Expr) -> String raise SqlglotError

    Generator::rowformatdelimitedproperty_sql

    source
    fn Generator::rowformatdelimitedproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::safedivide_sql

    source
    fn Generator::safedivide_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::sanitize_comment

    source
    fn Generator::sanitize_comment(self : Generator, comment : String) -> String

    Generator::schema_columns_sql

    source
    fn Generator::schema_columns_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::schema_sql

    source
    fn Generator::schema_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::scope_resolution

    source
    fn Generator::scope_resolution(self : Generator, rhs : String, scope_name : String) -> String raise SqlglotError

    Virtual scope_resolution.

    Generator::scope_resolution_base

    source
    fn Generator::scope_resolution_base(self : Generator, rhs : String, scope_name : String) -> String raise SqlglotError

    Generator::scoperesolution_sql

    source
    fn Generator::scoperesolution_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::seg

    source
    fn Generator::seg(self : Generator, sql : String, sep? : String) -> String

    Generator::select_sql

    source
    fn Generator::select_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::semanticview_sql

    source
    fn Generator::semanticview_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::semicolon_sql

    source
    fn Generator::semicolon_sql(self : Generator, expression : Expr) -> String

    Generator::sep

    source
    fn Generator::sep(self : Generator, sep? : String) -> String

    Generator::sequenceproperties_sql

    source
    fn Generator::sequenceproperties_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::sessionparameter_sql

    source
    fn Generator::sessionparameter_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::set_operation

    source
    fn Generator::set_operation(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::set_operations

    source
    fn Generator::set_operations(self : Generator, expression : Expr) -> String raise SqlglotError

    Virtual set_operations.

    Generator::set_operations_base

    source
    fn Generator::set_operations_base(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::set_sql

    source
    fn Generator::set_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::setitem_sql

    source
    fn Generator::setitem_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::show_sql

    source
    fn Generator::show_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::similarto_sql

    source
    fn Generator::similarto_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::simplify_unless_literal

    source
    fn Generator::simplify_unless_literal(self : Generator, expression : Expr) -> Expr raise SqlglotError

    Generator::skipjsoncolumn_sql

    source
    fn Generator::skipjsoncolumn_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::slice_sql

    source
    fn Generator::slice_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::sort_sql

    source
    fn Generator::sort_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::space_sql

    source
    fn Generator::space_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::sql

    source
    fn Generator::sql(self : Generator, expression : Expr?, comment? : Bool) -> String raise SqlglotError

    Generates SQL for an expression (Python self.sql(expression)).

    Generator::sql_key

    source
    fn Generator::sql_key(self : Generator, expression : Expr, key : String) -> String raise SqlglotError

    Python self.sql(expression, key).

    Generator::sql_value

    source
    fn Generator::sql_value(self : Generator, value : Value, comment? : Bool) -> String raise SqlglotError

    Python self.sql(value) for an argument value.

    Generator::star_sql

    source
    fn Generator::star_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::storedprocedure_sql

    source
    fn Generator::storedprocedure_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::string_sql

    source
    fn Generator::string_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::strtodate_sql

    source
    fn Generator::strtodate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::strtotime_sql

    source
    fn Generator::strtotime_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::struct_sql

    source
    fn Generator::struct_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::sub_sql

    source
    fn Generator::sub_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::subquery_sql

    source
    fn Generator::subquery_sql(self : Generator, expression : Expr, sep? : String) -> String raise SqlglotError

    Generator::summarize_sql

    source
    fn Generator::summarize_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::table_parts

    source
    fn Generator::table_parts(self : Generator, expression : Expr) -> String raise SqlglotError

    Virtual table_parts.

    Generator::table_parts_base

    source
    fn Generator::table_parts_base(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::table_prefixed_sql

    source
    fn Generator::table_prefixed_sql(self : Generator, expression : Expr, key : String) -> String raise SqlglotError

    Generator::table_sql

    source
    fn Generator::table_sql(self : Generator, expression : Expr, sep? : String) -> String raise SqlglotError

    Generator::table_sql_v

    source
    fn Generator::table_sql_v(self : Generator, expression : Expr, sep? : String) -> String raise SqlglotError

    Virtual table_sql(expression, sep).

    Generator::tablealias_sql

    source
    fn Generator::tablealias_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tablefromrows_sql

    source
    fn Generator::tablefromrows_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tablesample_sql

    source
    fn Generator::tablesample_sql(self : Generator, expression : Expr, tablesample_keyword? : String) -> String raise SqlglotError

    Generator::tablesample_sql_v

    source
    fn Generator::tablesample_sql_v(self : Generator, expression : Expr, tablesample_keyword? : String) -> String raise SqlglotError

    Virtual tablesample_sql(expression, tablesample_keyword).

    Generator::tag_sql

    source
    fn Generator::tag_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::timeserieskey_sql

    source
    fn Generator::timeserieskey_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::toarray_sql

    source
    fn Generator::toarray_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tochar_sql

    source
    fn Generator::tochar_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::todouble_sql

    source
    fn Generator::todouble_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::token_sql

    source
    fn Generator::token_sql(self : Generator, token_type : TokenType) -> String

    Generator::tonumber_cast_sql

    source
    fn Generator::tonumber_cast_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Python _tonumber_cast_sql.

    Generator::tonumber_sql

    source
    fn Generator::tonumber_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::too_wide

    source
    fn Generator::too_wide(self : Generator, args : Array[String]) -> Bool

    Generator::transaction_sql

    source
    fn Generator::transaction_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::translatecharacters_sql

    source
    fn Generator::translatecharacters_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::triggerevent_sql

    source
    fn Generator::triggerevent_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::triggerproperties_sql

    source
    fn Generator::triggerproperties_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::triggerreferencing_sql

    source
    fn Generator::triggerreferencing_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::trim_sql

    source
    fn Generator::trim_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::truncatetable_sql

    source
    fn Generator::truncatetable_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::try_sql

    source
    fn Generator::try_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::trycast_sql

    source
    fn Generator::trycast_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tsordstodate_sql

    source
    fn Generator::tsordstodate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tsordstodatetime_sql

    source
    fn Generator::tsordstodatetime_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tsordstotime_sql

    source
    fn Generator::tsordstotime_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tsordstotimestamp_sql

    source
    fn Generator::tsordstotimestamp_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::tuple_sql

    source
    fn Generator::tuple_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::uncache_sql

    source
    fn Generator::uncache_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::unicodestring_sql

    source
    fn Generator::unicodestring_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::uniquecolumnconstraint_sql

    source
    fn Generator::uniquecolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::uniquekeyproperty_sql

    source
    fn Generator::uniquekeyproperty_sql(self : Generator, expression : Expr, prefix? : String) -> String raise SqlglotError

    Generator::uniquekeyproperty_sql_v

    source
    fn Generator::uniquekeyproperty_sql_v(self : Generator, expression : Expr, prefix? : String) -> String raise SqlglotError

    Virtual uniquekeyproperty_sql(expression, prefix).

    Generator::unixdate_sql

    source
    fn Generator::unixdate_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::unixseconds_sql

    source
    fn Generator::unixseconds_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::unnest_sql

    source
    fn Generator::unnest_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::unpivotcolumns_sql

    source
    fn Generator::unpivotcolumns_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::unsupported

    source
    fn Generator::unsupported(self : Generator, message : String) -> Unit raise SqlglotError

    Generator::unsupported_args

    source
    fn Generator::unsupported_args(self : Generator, expression : Expr, args : Array[String]) -> Unit raise SqlglotError

    The @unsupported_args(...) decorator check.

    Generator::unsupported_stmt

    source
    fn Generator::unsupported_stmt(self : Generator, message : String) -> String raise SqlglotError

    Generator::update_from_joins_sql

    source
    fn Generator::update_from_joins_sql(self : Generator, expression : Expr) -> (String, String) raise SqlglotError

    Python _update_from_joins_sql: returns (join_sql, from_sql).

    Generator::update_sql

    source
    fn Generator::update_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::use_sql

    source
    fn Generator::use_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::userdefinedfunction_sql

    source
    fn Generator::userdefinedfunction_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::usingproperty_sql

    source
    fn Generator::usingproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::uuid_sql

    source
    fn Generator::uuid_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::uuidproperty_sql

    source
    fn Generator::uuidproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::values_sql

    source
    fn Generator::values_sql(self : Generator, expression : Expr, values_as_table? : Bool) -> String raise SqlglotError

    Generator::values_sql_v

    source
    fn Generator::values_sql_v(self : Generator, expression : Expr, values_as_table? : Bool) -> String raise SqlglotError

    Virtual values_sql(expression, values_as_table).

    Generator::var_sql

    source
    fn Generator::var_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::vectorsearch_sql

    source
    fn Generator::vectorsearch_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::version_sql

    source
    fn Generator::version_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::watermarkcolumnconstraint_sql

    source
    fn Generator::watermarkcolumnconstraint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::weekstart_name

    source
    fn Generator::weekstart_name(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::weekstart_sql

    source
    fn Generator::weekstart_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::when_sql

    source
    fn Generator::when_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::whens_sql

    source
    fn Generator::whens_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::where_sql

    source
    fn Generator::where_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::whileblock_sql

    source
    fn Generator::whileblock_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::window_sql

    source
    fn Generator::window_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::windowspec_sql

    source
    fn Generator::windowspec_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::with_properties

    source
    fn Generator::with_properties(self : Generator, properties : Expr) -> String raise SqlglotError

    Virtual with_properties.

    Generator::with_properties_base

    source
    fn Generator::with_properties_base(self : Generator, properties : Expr) -> String raise SqlglotError

    Generator::with_sql

    source
    fn Generator::with_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::withdataproperty_sql

    source
    fn Generator::withdataproperty_sql(self : Generator, expression : Expr) -> String

    Generator::withfill_sql

    source
    fn Generator::withfill_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::withingroup_sql

    source
    fn Generator::withingroup_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::withsystemversioningproperty_sql

    source
    fn Generator::withsystemversioningproperty_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::withtablehint_sql

    source
    fn Generator::withtablehint_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::wrap

    source
    fn Generator::wrap(self : Generator, expression : Expr) -> String raise SqlglotError

    wrap(expression) for an expression.

    Generator::wrap_sql

    source
    fn Generator::wrap_sql(self : Generator, this_sql : String) -> String

    Generator::wrap_str

    source
    fn Generator::wrap_str(self : Generator, sql : String) -> String

    wrap(sql) for an already generated SQL string.

    Generator::xmlelement_sql

    source
    fn Generator::xmlelement_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::xmlkeyvalueoption_sql

    source
    fn Generator::xmlkeyvalueoption_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::xmlnamespace_sql

    source
    fn Generator::xmlnamespace_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::xmltable_sql

    source
    fn Generator::xmltable_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    Generator::xor_sql

    source
    fn Generator::xor_sql(self : Generator, expression : Expr) -> String raise SqlglotError

    GeneratorConfig

    source
    pub(all) struct GeneratorConfig {
      alter_set_type : String
      alter_set_wrapped : Bool
      alter_table_include_column_keyword : Bool
      array_concat_is_var_len : Bool
      array_size_dim_required : Bool?
      array_size_name : String
      auto_refresh_bare_intervals : Bool
      can_implement_array_any : Bool
      collate_is_func : Bool
      computed_column_with_type : Bool
      copy_has_into_keyword : Bool
      copy_params_are_wrapped : Bool
      copy_params_eq_required : Bool
      create_function_return_as : Bool
      cte_recursive_keyword_required : Bool
      data_type_specifiers_allowed : Bool
      declare_default_assignment : String
      directed_joins : Bool
      duplicate_key_update_with_set : Bool
      ensure_bools : Bool
      except_intersect_support_all_clause : Bool
      exclude_comments : Array[Kind]
      expressions_without_nested_ctes : Array[Kind]
      expression_precedes_properties_creatables : 
    Set    [String]
      extract_allows_quotes : Bool
      groupings_sep : String
      hex_func : String
      historical_data_post_alias : Bool
      ignore_nulls_before_order : Bool
      ignore_nulls_in_func : Bool
      index_on : String
      inout_separator : String
      insert_overwrite : String
      interval_allows_plural_form : Bool
      is_bool_allowed : Bool
      join_hints : Bool
      json_key_value_pair_sep : String
      json_path_bracketed_key_supported : Bool
      json_path_key_quoted_forces_brackets : Bool
      json_path_single_quote_escape : Bool
      json_type_required_for_extraction : Bool
      last_day_supports_date_part : Bool
      like_property_inside_schema : Bool
      limit_fetch : String
      limit_is_top : Bool
      limit_only_literals : Bool
      locking_reads_supported : Bool
      matched_by_source : Bool
      match_against_table_prefix : String?
      mod_operator : String
      mod_paren_parent_types : Array[Kind]
      multi_arg_distinct : Bool
      named_placeholder_token : String
      normalize_extract_date_parts : Bool
      null_ordering_supported : Bool?
      nvl2_supported : Bool
      pad_fill_pattern_is_required : Bool
      parameterizable_text_types : Array[DType]
      parameter_token : String
      parse_json_name : String?
      pivot_alias_with_as : Bool
      properties_location : Map[Kind, PropertiesLocation]
      query_hints : Bool
      query_hint_sep : String
      quote_json_path : Bool
      rename_table_with_db : Bool
      reserved_keywords : 
    Set    [String]
      respect_ignore_nulls_unsupported_expressions : Array[Kind]
      returning_end : Bool
      select_kinds : Array[String]
      semi_anti_join_with_side : Bool
      sentinel_line_break : String
      set_assignment_requires_variable_keyword : Bool
      set_op_limits : Bool
      set_op_modifiers : Bool
      set_op_parenthesized_operands : Bool
      single_string_interval : Bool
      star_except : String
      star_exclude_requires_derived_table : Bool
      struct_delimiter : Array[String]
      supported_json_path_parts : Array[Kind]
      supports_alter_column_if_exists : Bool
      supports_alter_column_nullability : Bool
      supports_between_flags : Bool
      supports_change_column : Bool
      supports_convert_timezone : Bool
      supports_create_table_like : Bool
      supports_decode_case : Bool
      supports_drop_alter_iceberg_property : Bool
      supports_exploding_projections : Bool
      supports_grouping_sets_as_suffix : Bool
      supports_like_quantifiers : Bool
      supports_median : Bool
      supports_merge_where : Bool
      supports_modify_column : Bool
      supports_named_cte_columns : Bool
      supports_select_into : Bool
      supports_single_arg_concat : Bool
      supports_table_alias_columns : Bool
      supports_table_copy : Bool
      supports_to_number : Bool
      supports_uescape : Bool
      supports_unix_seconds : Bool
      supports_unlogged_tables : Bool
      supports_window_exclude : Bool
      tablesample_keywords : String
      tablesample_requires_parens : Bool
      tablesample_seed_keyword : String
      tablesample_size_is_rows : Bool
      tablesample_with_method : Bool
      table_hints : Bool
      time_part_singulars : Map[String, String]
      token_mapping : Map[TokenType, String]
      try_supported : Bool
      type_mapping : Map[DType, String]
      tz_to_with_time_zone : Bool
      unnest_with_ordinality : Bool
      unpivot_aliases_are_identifiers : Bool
      unsupported_types : Array[DType]
      unwrapped_interval_values : Array[Kind]
      update_statement_supports_from : Bool
      values_as_table : Bool
      window_funcs_with_null_ordering : Array[Kind]
      with_properties_prefix : String
      with_separated_comments : Array[Kind]
      wrap_derived_values : Bool
    }

    Data attributes of the Python Generator class.

    GeneratorConfig::copy

    source

    GeneratorFns

    source
    pub(all) struct GeneratorFns {
      transforms : Map[Kind, (Generator, Expr) -> String raise SqlglotError]
      methods : Map[Kind, (Generator, Expr) -> String raise SqlglotError]
      hooks : GeneratorHooks
      type_param_settings : Map[DType, (Array[Int], Array[Int?])]
      after_having_modifier_transforms : Array[(String, (Generator, Expr) -> String raise SqlglotError)]
    }

    Callable class attributes of the Python Generator plus method override hooks.

    GeneratorFns::copy

    source

    GeneratorHooks

    source
    pub(all) struct GeneratorHooks {
      add_column_sql : (Generator, Expr) -> String raise SqlglotError?
      after_limit_modifiers : (Generator, Expr) -> Array[String] raise SqlglotError?
      column_parts : (Generator, Expr) -> String raise SqlglotError?
      createable_sql : (Generator, Expr, Map[PropertiesLocation, Array[Expr]]) -> String raise SqlglotError?
      format_time : (Generator, Expr, Map[String, String]?, Trie?) -> String? raise SqlglotError?
      generate : (Generator, Expr, Bool) -> String raise SqlglotError?
      in_unnest_op : (Generator, Expr) -> String raise SqlglotError?
      lateral_op : (Generator, Expr) -> String raise SqlglotError?
      locate_properties : (Generator, Expr) -> Map[PropertiesLocation, Array[Expr]] raise SqlglotError?
      offset_limit_modifiers : (Generator, Expr, Bool, Expr?) -> Array[String] raise SqlglotError?
      options_modifier : (Generator, Expr) -> String raise SqlglotError?
      scope_resolution : (Generator, String, String) -> String raise SqlglotError?
      set_operations : (Generator, Expr) -> String raise SqlglotError?
      table_parts : (Generator, Expr) -> String raise SqlglotError?
      with_properties : (Generator, Expr) -> String raise SqlglotError?
      preprocess : (Generator, Expr) -> Expr raise SqlglotError?
      alterrename_sql : (Generator, Expr, Bool) -> String raise SqlglotError?
      arrayinsert_sql : (Generator, Expr, Int) -> String raise SqlglotError?
      cast_sql : (Generator, Expr, String?) -> String raise SqlglotError?
      chr_sql : (Generator, Expr, String) -> String raise SqlglotError?
      columndef_sql : (Generator, Expr, String) -> String raise SqlglotError?
      hexstring_sql : (Generator, Expr, String?) -> String raise SqlglotError?
      lambda_sql : (Generator, Expr, String, Bool) -> String raise SqlglotError?
      table_sql : (Generator, Expr, String) -> String raise SqlglotError?
      tablesample_sql : (Generator, Expr, String?) -> String raise SqlglotError?
      uniquekeyproperty_sql : (Generator, Expr, String) -> String raise SqlglotError?
      values_sql : (Generator, Expr, Bool) -> String raise SqlglotError?
      unicode_substitute : (String) -> String?
      safe_json_path_key_re : (String) -> Bool?
    }

    Typed hooks for Generator methods that dialects override and that are called virtually from base code (or have extra parameters).

    GeneratorHooks::copy

    source

    GeneratorHooks::new

    source

    Kind

    source
    pub(all) enum Kind {
      AIAgg
      AIClassify
      AIEmbed
      AIForecast
      AIGenerate
      AISimilarity
      AISummarizeAgg
      Abs
      Acos
      Acosh
      Add
      AddConstraint
      AddMonths
      AddPartition
      Adjacent
      Agg
      AggFunc
      AlgorithmProperty
      Alias
      Aliases
      All
      AllowedValuesProperty
      Alter
      AlterColumn
      AlterDistStyle
      AlterIndex
      AlterModifySqlSecurity
      AlterRename
      AlterSession
      AlterSet
      AlterSortKey
      Analyze
      AnalyzeColumns
      AnalyzeDelete
      AnalyzeHistogram
      AnalyzeListChainedRows
      AnalyzeSample
      AnalyzeStatistics
      AnalyzeValidate
      AnalyzeWith
      And
      Anonymous
      AnonymousAggFunc
      Any
      AnyValue
      ApiProperty
      ApplicationProperty
      Apply
      ApproxDistinct
      ApproxPercentileAccumulate
      ApproxPercentileCombine
      ApproxPercentileEstimate
      ApproxQuantile
      ApproxQuantiles
      ApproxTopK
      ApproxTopKAccumulate
      ApproxTopKCombine
      ApproxTopKEstimate
      ApproxTopSum
      ApproximateSimilarity
      ArgMax
      ArgMin
      Array
      ArrayAgg
      ArrayAll
      ArrayAny
      ArrayAppend
      ArrayCompact
      ArrayConcat
      ArrayConcatAgg
      ArrayConstructCompact
      ArrayContainedBy
      ArrayContains
      ArrayContainsAll
      ArrayDistinct
      ArrayExcept
      ArrayFilter
      ArrayFirst
      ArrayInsert
      ArrayIntersect
      ArrayLast
      ArrayMax
      ArrayMin
      ArrayOverlaps
      ArrayPosition
      ArrayPrepend
      ArrayRemove
      ArrayRemoveAt
      ArrayReverse
      ArraySize
      ArraySlice
      ArraySort
      ArraySum
      ArrayToString
      ArrayUnionAgg
      ArrayUniqueAgg
      ArraysZip
      Ascii
      Asin
      Asinh
      AssumeColumnConstraint
      AtIndex
      AtTimeZone
      Atan
      Atan2
      Atanh
      Attach
      AttachOption
      AutoIncrementColumnConstraint
      AutoIncrementProperty
      AutoRefreshProperty
      Avg
      BackupProperty
      Base64DecodeBinary
      Base64DecodeString
      Base64Encode
      Between
      Binary
      BinaryColumnConstraint
      BitLength
      BitString
      BitmapBitPosition
      BitmapBucketNumber
      BitmapConstructAgg
      BitmapCount
      BitmapOrAgg
      BitwiseAnd
      BitwiseAndAgg
      BitwiseCount
      BitwiseLeftShift
      BitwiseNot
      BitwiseOr
      BitwiseOrAgg
      BitwiseRightShift
      BitwiseXor
      BitwiseXorAgg
      Block
      BlockCompressionProperty
      Booland
      Boolean
      Boolnot
      Boolor
      BoolxorAgg
      Bracket
      BuildProperty
      ByteLength
      ByteString
      CTE
      Cache
      CalledOnNullInputProperty
      Case
      CaseSpecificColumnConstraint
      CaseStatement
      Cast
      CastToStrType
      CatalogProperty
      Cbrt
      Ceil
      Changes
      CharacterSet
      CharacterSetColumnConstraint
      CharacterSetProperty
      Check
      CheckColumnConstraint
      CheckJson
      CheckXml
      ChecksumProperty
      Chr
      CityHash64
      Clone
      Cluster
      ClusterProperty
      ClusteredByProperty
      ClusteredColumnConstraint
      Coalesce
      CodePointsToBytes
      CodePointsToString
      Collate
      CollateColumnConstraint
      CollateProperty
      Collation
      Column
      ColumnConstraint
      ColumnConstraintKind
      ColumnDef
      ColumnPosition
      ColumnPrefix
      Columns
      CombinedAggFunc
      CombinedParameterizedAgg
      Command
      Comment
      CommentColumnConstraint
      Commit
      Comprehension
      Compress
      CompressColumnConstraint
      ComputeProperty
      ComputedColumnConstraint
      Concat
      ConcatWs
      Condition
      ConditionalInsert
      Connect
      ConnectByRoot
      Connector
      Constraint
      Contains
      Convert
      ConvertTimezone
      ConvertToCharset
      Copy
      CopyGrantsProperty
      CopyParameter
      Corr
      Cos
      Cosh
      CosineDistance
      Cot
      Coth
      Count
      CountIf
      CovarPop
      CovarSamp
      Create
      Credentials
      CredentialsProperty
      Csc
      Csch
      Cube
      CumeDist
      CurrentAccount
      CurrentAccountName
      CurrentAvailableRoles
      CurrentCatalog
      CurrentClient
      CurrentDatabase
      CurrentDate
      CurrentDatetime
      CurrentIpAddress
      CurrentOrganizationName
      CurrentOrganizationUser
      CurrentRegion
      CurrentRole
      CurrentRoleType
      CurrentSchema
      CurrentSchemas
      CurrentSecondaryRoles
      CurrentSession
      CurrentStatement
      CurrentTime
      CurrentTimestamp
      CurrentTimestampLTZ
      CurrentTimezone
      CurrentTransaction
      CurrentUser
      CurrentUserId
      CurrentVersion
      CurrentWarehouse
      DDL
      DML
      DPipe
      DataBlocksizeProperty
      DataDeletionProperty
      DataType
      DataTypeParam
      DatabaseProperty
      Date
      DateAdd
      DateBin
      DateDiff
      DateFormatColumnConstraint
      DateFromParts
      DateFromUnixDate
      DateStrToDate
      DateSub
      DateToDateStr
      DateToDi
      DateTrunc
      Datetime
      DatetimeAdd
      DatetimeDiff
      DatetimeSub
      DatetimeTrunc
      Day
      DayOfMonth
      DayOfWeek
      DayOfWeekIso
      DayOfYear
      Dayname
      Declare
      DeclareItem
      Decode
      DecodeCase
      DecompressBinary
      DecompressString
      Decrypt
      DecryptRaw
      DefaultColumnConstraint
      DefinerProperty
      Degrees
      Delete
      DenseRank
      DerivedTable
      Describe
      Detach
      DiToDate
      DictProperty
      DictRange
      DictSubProperty
      Directory
      DirectoryStage
      DistKeyProperty
      DistStyleProperty
      Distance
      DistanceNd
      Distinct
      Distribute
      DistributedByProperty
      Div
      Dot
      DotProduct
      Drop
      DropPartition
      DropPrimaryKey
      DuplicateKeyProperty
      DynamicIdentifier
      DynamicProperty
      EQ
      Elt
      EmptyProperty
      Encode
      EncodeColumnConstraint
      EncodeProperty
      Encrypt
      EncryptRaw
      EndStatement
      EndsWith
      EngineProperty
      EnviromentProperty
      EphemeralColumnConstraint
      EqualNull
      Escape
      EuclideanDistance
      Except
      ExcludeColumnConstraint
      Execute
      ExecuteAsProperty
      ExecuteSql
      Exists
      Exp
      Explode
      ExplodeOuter
      ExplodingGenerateSeries
      Export
      Expression
      ExtendsLeft
      ExtendsRight
      ExternalProperty
      Extract
      Factorial
      FallbackProperty
      FarmFingerprint
      FeaturesAtTime
      Fetch
      FileFormatProperty
      Filter
      Final
      First
      FirstValue
      Flatten
      Float64
      Floor
      ForClause
      ForIn
      ForceProperty
      ForeignKey
      Format
      FormatJson
      FormatPhrase
      FreespaceProperty
      From
      FromBase
      FromBase32
      FromBase64
      FromISO8601Date
      FromISO8601Timestamp
      FromISO8601TimestampNanos
      FromJson
      FromTimeZone
      Func
      FunctionSpecification
      GT
      GTE
      GapFill
      GenerateBool
      GenerateDateArray
      GenerateDouble
      GenerateEmbedding
      GenerateInt
      GenerateSeries
      GenerateTable
      GenerateText
      GenerateTimestampArray
      GeneratedAsIdentityColumnConstraint
      GeneratedAsRowColumnConstraint
      Generator
      Get
      GetExtract
      GetIgnoreCase
      Getbit
      Glob
      GlobalProperty
      Grant
      GrantPrincipal
      GrantPrivilege
      Greatest
      Group
      GroupConcat
      Grouping
      GroupingId
      GroupingSets
      HandlerProperty
      HashAgg
      Having
      HavingMax
      HeapProperty
      Heredoc
      Hex
      HexDecodeString
      HexString
      Hint
      HistoricalData
      Hll
      Host
      Hour
      HybridProperty
      ILike
      IcebergProperty
      Identifier
      If
      IfBlock
      IgnoreNulls
      In
      InOutColumnConstraint
      IncludeProperty
      Index
      IndexColumnConstraint
      IndexConstraintOption
      IndexParameters
      IndexTableHint
      InheritsProperty
      Initcap
      Inline
      InlineLengthColumnConstraint
      InputModelProperty
      InputOutputFormat
      Insert
      Install
      Int64
      IntDiv
      Intersect
      Interval
      IntervalOp
      IntervalSpan
      Into
      Introducer
      InvisibleColumnConstraint
      Is
      IsArray
      IsAscii
      IsInf
      IsNan
      IsNullValue
      IsolatedLoadingProperty
      Iterate
      JSON
      JSONArray
      JSONArrayAgg
      JSONArrayAppend
      JSONArrayContains
      JSONArrayInsert
      JSONBContains
      JSONBContainsAllTopKeys
      JSONBContainsAnyTopKeys
      JSONBContainsTopKey
      JSONBDeleteAtPath
      JSONBExists
      JSONBExtract
      JSONBExtractScalar
      JSONBObjectAgg
      JSONBPathExists
      JSONBool
      JSONCast
      JSONColumnDef
      JSONExists
      JSONExtract
      JSONExtractArray
      JSONExtractQuote
      JSONExtractScalar
      JSONFormat
      JSONKeyValue
      JSONKeys
      JSONKeysAtDepth
      JSONObject
      JSONObjectAgg
      JSONPath
      JSONPathFilter
      JSONPathKey
      JSONPathPart
      JSONPathRecursive
      JSONPathRoot
      JSONPathScript
      JSONPathSelector
      JSONPathSlice
      JSONPathSubscript
      JSONPathUnion
      JSONPathWildcard
      JSONRemove
      JSONSchema
      JSONSet
      JSONStripNulls
      JSONTable
      JSONType
      JSONValue
      JSONValueArray
      JarowinklerSimilarity
      Join
      JoinHint
      JournalProperty
      JustifyDays
      JustifyHours
      JustifyInterval
      Kill
      Kurtosis
      Kwarg
      LT
      LTE
      Lag
      Lambda
      LanguageProperty
      Last
      LastDay
      LastValue
      Lateral
      LaxBool
      LaxFloat64
      LaxInt64
      LaxString
      Lead
      Least
      Leave
      Left
      Length
      Levenshtein
      Like
      LikeProperty
      Limit
      LimitOptions
      List
      Literal
      Ln
      LoadData
      Localtime
      Localtimestamp
      LocationProperty
      Lock
      LockProperty
      LockingProperty
      LockingStatement
      Log
      LogProperty
      LogicalAnd
      LogicalOr
      LoopBlock
      Lower
      LowerHex
      MD5
      MD5Digest
      MD5NumberLower64
      MD5NumberUpper64
      MLForecast
      MLTranslate
      MacroOverload
      MacroOverloads
      MakeInterval
      ManhattanDistance
      Map
      MapCat
      MapContainsKey
      MapDelete
      MapFromEntries
      MapInsert
      MapKeys
      MapPick
      MapSize
      MaskingPolicyColumnConstraint
      MaskingProperty
      Match
      MatchAgainst
      MatchRecognize
      MatchRecognizeMeasure
      MaterializedProperty
      Max
      Median
      Merge
      MergeBlockRatioProperty
      MergeTreeTTL
      MergeTreeTTLAction
      Min
      Minhash
      MinhashCombine
      Minute
      Mod
      Mode
      ModelAttribute
      ModifyColumn
      ModuleProperty
      Month
      Monthname
      MonthsBetween
      Mul
      MultitableInserts
      NEQ
      Nanvl
      National
      Neg
      Negative
      NestedJSONSelect
      NetFunc
      NetworkProperty
      NextDay
      NextValueFor
      NoPrimaryIndexProperty
      NonClusteredColumnConstraint
      Normal
      Normalize
      Not
      NotForReplicationColumnConstraint
      NotNullColumnConstraint
      NthValue
      Ntile
      Null
      NullSafeEQ
      NullSafeNEQ
      Nullif
      NumberToStr
      Nvl2
      ObjectAgg
      ObjectId
      ObjectIdentifier
      ObjectInsert
      ObjectTransform
      Offset
      OnCluster
      OnCommitProperty
      OnCondition
      OnConflict
      OnProperty
      OnUpdateColumnConstraint
      Opclass
      OpenJSON
      OpenJSONColumnDef
      Operator
      Or
      Order
      Ordered
      OutputModelProperty
      OverflowTruncateBehavior
      Overlaps
      Overlay
      Pad
      Parameter
      ParameterStyleProperty
      ParameterizedAgg
      Paren
      ParseBignumeric
      ParseDatetime
      ParseIp
      ParseJSON
      ParseNumeric
      ParseTime
      ParseUrl
      Partition
      PartitionBoundSpec
      PartitionByListProperty
      PartitionByRangeProperty
      PartitionByRangePropertyDynamic
      PartitionByTruncate
      PartitionId
      PartitionList
      PartitionRange
      PartitionedByBucket
      PartitionedByProperty
      PartitionedOfProperty
      PathColumnConstraint
      PercentRank
      PercentileCont
      PercentileDisc
      PeriodForSystemTimeConstraint
      Pi
      Pivot
      PivotAlias
      PivotAny
      Placeholder
      Posexplode
      PosexplodeOuter
      PositionalColumn
      Pow
      Pragma
      PreWhere
      Predicate
      Predict
      PreviousDay
      PrimaryKey
      PrimaryKeyColumnConstraint
      Prior
      ProjectionDef
      ProjectionPolicyColumnConstraint
      Properties
      Property
      PropertyEQ
      PseudoType
      Pseudocolumn
      Put
      Qualify
      Quantile
      Quarter
      Query
      QueryBand
      QueryOption
      QueryTransform
      Radians
      Rand
      Randn
      Randstr
      RangeBucket
      RangeN
      Rank
      RawString
      ReadCSV
      ReadParquet
      RecursiveWithSearch
      Reduce
      Reference
      Refresh
      RefreshTriggerProperty
      RegDomain
      RegexpCount
      RegexpExtract
      RegexpExtractAll
      RegexpFullMatch
      RegexpILike
      RegexpInstr
      RegexpLike
      RegexpReplace
      RegexpSplit
      RegexpSubstr
      RegrAvgx
      RegrAvgy
      RegrCount
      RegrIntercept
      RegrR2
      RegrSlope
      RegrSxx
      RegrSxy
      RegrSyy
      RegrValx
      RegrValy
      RemoteWithConnectionModelProperty
      RenameColumn
      RenameIndex
      Repeat
      RepeatBlock
      Replace
      ReplacePartition
      RespectNulls
      Return
      Returning
      ReturnsProperty
      Reverse
      Revoke
      Right
      Rint
      Rollback
      Rollup
      RollupIndex
      RollupProperty
      Round
      RowAccessProperty
      RowFormatDelimitedProperty
      RowFormatProperty
      RowFormatSerdeProperty
      RowNumber
      RtrimmedLength
      SHA
      SHA1Digest
      SHA2
      SHA2Digest
      SafeAdd
      SafeConvertBytesToString
      SafeDivide
      SafeFunc
      SafeMultiply
      SafeNegate
      SafeSubtract
      SampleProperty
      Schema
      SchemaCommentProperty
      ScopeResolution
      Search
      SearchIp
      Sec
      Sech
      Second
      Secret
      SecureProperty
      SecurityIntegrationProperty
      Select
      Selectable
      SemanticView
      Semicolon
      Seq1
      Seq2
      Seq4
      Seq8
      SequenceProperties
      SerdeProperties
      SessionParameter
      SessionUser
      Set
      SetConfigProperty
      SetItem
      SetOperation
      SetProperty
      SettingsProperty
      SharingProperty
      Show
      Shuffle
      Sign
      SimilarTo
      Sin
      Sinh
      Skewness
      SkipJSONColumn
      Slice
      Sort
      SortArray
      SortKeyProperty
      Soundex
      SoundexP123
      Space
      Split
      SplitPart
      SqlReadWriteProperty
      SqlSecurityProperty
      Sqrt
      StDistance
      StPoint
      StabilityProperty
      Stack
      StandardHash
      Star
      StarMap
      StartsWith
      Stddev
      StddevPop
      StddevSamp
      StorageHandlerProperty
      StoredProcedure
      StrPosition
      StrToDate
      StrToMap
      StrToTime
      StrToUnix
      Stream
      StreamingTableProperty
      StrictProperty
      String
      StringToArray
      StripNullValue
      Strtok
      StrtokToArray
      Struct
      StructExtract
      Stuff
      Sub
      Subquery
      SubqueryPredicate
      Substring
      SubstringIndex
      Sum
      Summarize
      SwapTable
      Systimestamp
      Table
      TableAlias
      TableColumn
      TableFromRows
      TableSample
      Tag
      Tags
      Tan
      Tanh
      TemporaryProperty
      Time
      TimeAdd
      TimeDiff
      TimeFromParts
      TimeSlice
      TimeStrToDate
      TimeStrToTime
      TimeStrToUnix
      TimeSub
      TimeToStr
      TimeToTimeStr
      TimeToUnix
      TimeTrunc
      TimeUnit
      TimeseriesKey
      Timestamp
      TimestampAdd
      TimestampDiff
      TimestampFromParts
      TimestampLtzFromParts
      TimestampSub
      TimestampTrunc
      TimestampTzFromParts
      TitleColumnConstraint
      ToArray
      ToBase32
      ToBase64
      ToBinary
      ToBoolean
      ToChar
      ToCodePoints
      ToDays
      ToDecfloat
      ToDouble
      ToFile
      ToMap
      ToNumber
      ToTableProperty
      ToVariant
      Transaction
      Transform
      TransformModelProperty
      TransientProperty
      Translate
      TranslateCharacters
      TriggerEvent
      TriggerExecute
      TriggerProperties
      TriggerReferencing
      Trim
      Trunc
      TruncateTable
      Try
      TryBase64DecodeBinary
      TryBase64DecodeString
      TryCast
      TryHexDecodeBinary
      TryHexDecodeString
      TryToDecfloat
      TsOrDiToDi
      TsOrDsAdd
      TsOrDsDiff
      TsOrDsToDate
      TsOrDsToDateStr
      TsOrDsToDatetime
      TsOrDsToTime
      TsOrDsToTimestamp
      Tuple
      Typeof
      UDTF
      Unary
      Uncache
      Undrop
      Unhex
      Unicode
      UnicodeString
      Uniform
      Union
      UniqueColumnConstraint
      UniqueKeyProperty
      UnixDate
      UnixMicros
      UnixMillis
      UnixSeconds
      UnixToStr
      UnixToTime
      UnixToTimeStr
      UnloggedProperty
      Unnest
      UnpivotColumns
      Update
      Upper
      UppercaseColumnConstraint
      Use
      UserDefinedFunction
      UsingData
      UsingProperty
      UsingTemplateProperty
      UtcDate
      UtcTime
      UtcTimestamp
      Uuid
      UuidProperty
      Values
      Var
      VarMap
      Variadic
      Variance
      VariancePop
      VectorSearch
      Version
      ViewAttributeProperty
      VirtualProperty
      VolatileProperty
      WatermarkColumnConstraint
      Week
      WeekOfYear
      WeekStart
      When
      Whens
      Where
      WhileBlock
      WidthBucket
      Window
      WindowSpec
      With
      WithDataProperty
      WithFill
      WithJournalTableProperty
      WithOperator
      WithProcedureOptions
      WithSchemaBindingProperty
      WithSystemVersioningProperty
      WithTableHint
      WithinGroup
      XMLElement
      XMLGet
      XMLKeyValueOption
      XMLNamespace
      XMLTable
      Xor
      Year
      YearOfWeek
      YearOfWeekIso
      ZeroFillColumnConstraint
      Zipf
      PrivExplodeOuter
      PrivTimeUnit
    } derive(Eq, Hash)

    Every expression class of sqlglot, including abstract traits.
    impl Show for Kind

    Kind::arg_types

    source
    fn Kind::arg_types(self : Kind) -> FixedArray[(String, Bool)]

    Kind::class_path

    source
    fn Kind::class_path(self : Kind) -> String

    Python str(cls), e.g. <class 'sqlglot.expressions.query.Select'>.

    Kind::has_arg

    source
    fn Kind::has_arg(self : Kind, key : String) -> Bool

    Kind::hash_raw_args

    source
    fn Kind::hash_raw_args(self : Kind) -> Bool

    Kind::id

    source
    fn Kind::id(self : Kind) -> Int

    Kind::is_a

    source
    fn Kind::is_a(self : Kind, base : Kind) -> Bool

    Whether self is base or a subclass of base (Python issubclass).

    Kind::is_any

    source
    fn Kind::is_any(self : Kind, bases : ArrayView[Kind]) -> Bool

    Whether self is a subclass of any of the given kinds.

    Kind::is_cast

    source
    fn Kind::is_cast(self : Kind) -> Bool

    Kind::is_data_type

    source
    fn Kind::is_data_type(self : Kind) -> Bool

    Kind::is_primitive

    source
    fn Kind::is_primitive(self : Kind) -> Bool

    Kind::is_subquery

    source
    fn Kind::is_subquery(self : Kind) -> Bool

    Kind::is_trait

    source
    fn Kind::is_trait(self : Kind) -> Bool

    Whether this kind is an abstract trait (e.g. Func, Binary) rather than a concrete node.

    Kind::is_var_len_args

    source
    fn Kind::is_var_len_args(self : Kind) -> Bool

    Kind::key

    source
    fn Kind::key(self : Kind) -> String

    The lowercase key of this kind, e.g. select.

    Kind::module_name

    source
    fn Kind::module_name(self : Kind) -> String

    The Python module defining this kind, e.g. sqlglot.expressions.query.

    Kind::name

    source
    fn Kind::name(self : Kind) -> String

    The Python class name of this kind, e.g. Select.

    Kind::owner_alias

    source
    fn Kind::owner_alias(self : Kind) -> Kind?

    The class in the MRO of self that defines alias (None for the base Expression).

    Kind::owner_alias_or_name

    source
    fn Kind::owner_alias_or_name(self : Kind) -> Kind?

    The class in the MRO of self that defines alias_or_name (None for the base Expression).

    Kind::owner_catalog

    source
    fn Kind::owner_catalog(self : Kind) -> Kind?

    The class in the MRO of self that defines catalog (None for the base Expression).

    Kind::owner_columns

    source
    fn Kind::owner_columns(self : Kind) -> Kind?

    The class in the MRO of self that defines columns (None for the base Expression).

    Kind::owner_ctes

    source
    fn Kind::owner_ctes(self : Kind) -> Kind?

    The class in the MRO of self that defines ctes (None for the base Expression).

    Kind::owner_db

    source
    fn Kind::owner_db(self : Kind) -> Kind?

    The class in the MRO of self that defines db (None for the base Expression).

    Kind::owner_is_int

    source
    fn Kind::owner_is_int(self : Kind) -> Kind?

    The class in the MRO of self that defines is_int (None for the base Expression).

    Kind::owner_is_number

    source
    fn Kind::owner_is_number(self : Kind) -> Kind?

    The class in the MRO of self that defines is_number (None for the base Expression).

    Kind::owner_is_star

    source
    fn Kind::owner_is_star(self : Kind) -> Kind?

    The class in the MRO of self that defines is_star (None for the base Expression).

    Kind::owner_is_string

    source
    fn Kind::owner_is_string(self : Kind) -> Kind?

    The class in the MRO of self that defines is_string (None for the base Expression).

    Kind::owner_is_type

    source
    fn Kind::owner_is_type(self : Kind) -> Kind?

    The class in the MRO of self that defines is_type (None for the base Expression).

    Kind::owner_kind

    source
    fn Kind::owner_kind(self : Kind) -> Kind?

    The class in the MRO of self that defines kind (None for the base Expression).

    Kind::owner_left

    source
    fn Kind::owner_left(self : Kind) -> Kind?

    The class in the MRO of self that defines left (None for the base Expression).

    Kind::owner_method

    source
    fn Kind::owner_method(self : Kind) -> Kind?

    The class in the MRO of self that defines method (None for the base Expression).

    Kind::owner_name

    source
    fn Kind::owner_name(self : Kind) -> Kind?

    The class in the MRO of self that defines name (None for the base Expression).

    Kind::owner_named_selects

    source
    fn Kind::owner_named_selects(self : Kind) -> Kind?

    The class in the MRO of self that defines named_selects (None for the base Expression).

    Kind::owner_output_name

    source
    fn Kind::owner_output_name(self : Kind) -> Kind?

    The class in the MRO of self that defines output_name (None for the base Expression).

    Kind::owner_parts

    source
    fn Kind::owner_parts(self : Kind) -> Kind?

    The class in the MRO of self that defines parts (None for the base Expression).

    Kind::owner_right

    source
    fn Kind::owner_right(self : Kind) -> Kind?

    The class in the MRO of self that defines right (None for the base Expression).

    Kind::owner_selects

    source
    fn Kind::owner_selects(self : Kind) -> Kind?

    The class in the MRO of self that defines selects (None for the base Expression).

    Kind::owner_side

    source
    fn Kind::owner_side(self : Kind) -> Kind?

    The class in the MRO of self that defines side (None for the base Expression).

    Kind::owner_table

    source
    fn Kind::owner_table(self : Kind) -> Kind?

    The class in the MRO of self that defines table (None for the base Expression).

    Kind::owner_this

    source
    fn Kind::owner_this(self : Kind) -> Kind?

    The class in the MRO of self that defines this (None for the base Expression).

    Kind::owner_to

    source
    fn Kind::owner_to(self : Kind) -> Kind?

    The class in the MRO of self that defines to (None for the base Expression).

    Kind::owner_to_py

    source
    fn Kind::owner_to_py(self : Kind) -> Kind?

    The class in the MRO of self that defines to_py (None for the base Expression).

    Kind::owner_unit

    source
    fn Kind::owner_unit(self : Kind) -> Kind?

    The class in the MRO of self that defines unit (None for the base Expression).

    Kind::owner_unnest

    source
    fn Kind::owner_unnest(self : Kind) -> Kind?

    The class in the MRO of self that defines unnest (None for the base Expression).

    Kind::sql_name

    source
    fn Kind::sql_name(self : Kind) -> String

    Kind::sql_names

    source
    fn Kind::sql_names(self : Kind) -> FixedArray[String]

    SQL names of a function kind (first is the canonical one).

    Kind::var_len_arg_key

    source
    fn Kind::var_len_arg_key(self : Kind) -> String

    NormalizationStrategy

    source
    pub(all) enum NormalizationStrategy {
      Lowercase
      Uppercase
      CaseSensitive
      CaseInsensitive
      CaseInsensitiveUppercase
    } derive(Eq, Hash, 
    Debug    )

    How a dialect normalizes identifiers.

    NumericEscape

    source
    pub(all) struct NumericEscape {
      base : Int
      min_digits : Int
      max_digits : Int
      max_value : Int
    }

    Numeric escape specification: (base, min digits, max digits, max value).

    ParseErrorInfo

    source
    pub(all) struct ParseErrorInfo {
      description : String
      line : Int
      col : Int
      start_context : String
      highlight : String
      end_context : String
      into_expression : String?
    } derive(
    Debug    )

    Details of a single parse error.

    Parser

    source
    pub(all) struct Parser {
      dialect : Dialect
      cfg : ParserConfig
      fns : ParserFns
      error_level : ErrorLevel
      error_message_context : Int
      max_errors : Int
      max_nodes : Int
      sql : String
      sql_offsets : Array[Int]?
      errors : Array[SqlglotError]
      tokens : Array[Token]
      tokens_size : Int
      index : Int
      curr : Token
      next : Token
      prev : Token
      prev_comments : Array[String]
      pipe_cte_counter : Int
      chunks : Array[Array[Token]]
      chunk_index : Int
      node_count : Int
    }

    Parser consumes a list of tokens produced by the Tokenizer and produces a parsed syntax tree.

    Parser::add_comments

    source
    fn Parser::add_comments(self : Parser, expression : Expr?) -> Unit

    Parser::advance

    source
    fn Parser::advance(self : Parser, times? : Int) -> Unit

    Parser::advance_any

    source
    fn Parser::advance_any(self : Parser, ignore_reserved? : Bool) -> Token?

    Parser::advance_chunk

    source
    fn Parser::advance_chunk(self : Parser) -> Unit

    Parser::andl

    source
    fn Parser::andl(self : Parser, cond : Bool, f : () -> Array[Expr] raise SqlglotError) -> Value? raise SqlglotError

    Python cond and f() where f returns a list.

    Parser::andv

    source
    fn Parser::andv(self : Parser, cond : Bool, f : () -> Expr? raise SqlglotError) -> Value? raise SqlglotError

    Python cond and f(): False when cond is false, else the result of f().

    Parser::build_cast

    source
    fn Parser::build_cast(self : Parser, strict : Bool, kwargs : Array[(String, Value?)]) -> Expr raise SqlglotError

    Parser::build_cast_base

    source
    fn Parser::build_cast_base(self : Parser, strict : Bool, kwargs : Array[(String, Value?)]) -> Expr raise SqlglotError

    Parser::build_json_extract

    source
    fn Parser::build_json_extract(self : Parser, this : Expr?, path_parts : Array[Expr]) -> (Expr?, Array[Expr]) raise SqlglotError

    Parser::build_pipe_cte

    source
    fn Parser::build_pipe_cte(self : Parser, query : Expr, expressions : Array[Expr], alias_cte? : Expr) -> Expr

    Parser::can_parse_limit_or_offset

    source
    fn Parser::can_parse_limit_or_offset(self : Parser) -> Bool

    Parser::can_parse_named_window

    source
    fn Parser::can_parse_named_window(self : Parser) -> Bool

    Parser::check_errors

    source
    fn Parser::check_errors(self : Parser) -> Unit raise SqlglotError

    Logs or raises any found errors, depending on the chosen error level setting.

    Parser::dialect_sql

    source
    fn Parser::dialect_sql(self : Parser, e : Expr) -> String raise SqlglotError

    Python f"{expr}": the SQL of an expression with the base dialect.

    Parser::expression

    source
    fn Parser::expression(self : Parser, instance : Expr, token? : Token, comments? : Array[String]) -> Expr raise SqlglotError

    Creates a new, validated Expr: attaches comments and position info.

    Parser::expression_opt

    source
    fn Parser::expression_opt(self : Parser, instance : Expr?) -> Expr? raise SqlglotError

    self.expression(...) for an optional instance.

    Parser::find_parser

    source
    fn[V] Parser::find_parser(self : Parser, parsers : Map[String, V], trie : WordTrie) -> V?

    Parser::find_sql

    source
    fn Parser::find_sql(self : Parser, start : Token, end : Token) -> String

    Parser::identifier_expression

    source
    fn Parser::identifier_expression(self : Parser, token? : Token, quoted? : Bool) -> Expr raise SqlglotError

    Parser::implicit_unnests_to_explicit

    source
    fn Parser::implicit_unnests_to_explicit(self : Parser, this : Expr) -> Expr

    Parser::is_connected

    source
    fn Parser::is_connected(self : Parser) -> Bool

    Parser::kv_to_prop_eq

    source
    fn Parser::kv_to_prop_eq(self : Parser, expressions : Array[Expr], parse_map? : Bool) -> Array[Expr] raise SqlglotError

    Parser::match_

    source
    fn Parser::match_(self : Parser, token_type : TokenType, advance? : Bool, expression? : Expr) -> Bool

    Parser::match_any

    source
    fn Parser::match_any(self : Parser, types : ArrayView[TokenType], advance? : Bool) -> Bool

    Parser::match_keys

    source
    fn[V] Parser::match_keys(self : Parser, m : Map[TokenType, V], advance? : Bool) -> Bool

    Parser::match_l_paren

    source
    fn Parser::match_l_paren(self : Parser, expression? : Expr) -> Unit raise SqlglotError

    Parser::match_pair

    source
    fn Parser::match_pair(self : Parser, a : TokenType, b : TokenType, advance? : Bool) -> Bool

    Parser::match_r_paren

    source
    fn Parser::match_r_paren(self : Parser, expression? : Expr) -> Unit raise SqlglotError

    Parser::match_set

    source
    fn Parser::match_set(self : Parser, types : TokenSet, advance? : Bool) -> Bool

    Parser::match_set_text

    source
    fn Parser::match_set_text(self : Parser, types : TokenSet) -> String?

    self._match_set(types) and self._prev.text.upper()

    Parser::match_text

    source
    fn Parser::match_text(self : Parser, text : String, advance? : Bool) -> Bool

    self._match_text_seq("X") for a single keyword.

    Parser::match_text_keys

    source
    fn[V] Parser::match_text_keys(self : Parser, texts : Map[String, V], advance? : Bool) -> Bool

    Parser::match_text_seq

    source
    fn Parser::match_text_seq(self : Parser, texts : ArrayView[String], advance? : Bool) -> Bool

    Parser::match_text_set

    source
    fn Parser::match_text_set(self : Parser, texts : 
    Set    [String], advance? : Bool) -> Bool

    Parser::match_texts

    source
    fn Parser::match_texts(self : Parser, texts : ArrayView[String], advance? : Bool) -> Bool

    Parser::match_texts_upper

    source
    fn Parser::match_texts_upper(self : Parser, texts : ArrayView[String]) -> String?

    self._match_texts(texts) and self._prev.text.upper()

    Parser::negate_range

    source
    fn Parser::negate_range(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::negate_range_base

    source
    fn Parser::negate_range_base(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::new

    source
    fn Parser::new(dialect : Dialect, error_level? : ErrorLevel, error_message_context? : Int, max_errors? : Int, max_nodes? : Int) -> Parser

    Parser::normalize_collate

    source
    fn Parser::normalize_collate(self : Parser, collate : Expr) -> Unit

    Parser::parse

    source
    fn Parser::parse(self : Parser, raw_tokens : Array[Token], sql : String) -> Array[Expr?] raise SqlglotError

    Parses a list of tokens and returns a list of syntax trees, one tree per parsed SQL statement.

    Parser::parse_add_column

    source
    fn Parser::parse_add_column(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alias

    source
    fn Parser::parse_alias(self : Parser, this : Expr?, explicit? : Bool) -> Expr? raise SqlglotError

    Parser::parse_alias_base

    source
    fn Parser::parse_alias_base(self : Parser, this : Expr?, explicit? : Bool) -> Expr? raise SqlglotError

    Parser::parse_alter

    source
    fn Parser::parse_alter(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_diststyle

    source
    fn Parser::parse_alter_diststyle(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_drop_action

    source
    fn Parser::parse_alter_drop_action(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_session

    source
    fn Parser::parse_alter_session(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_sortkey

    source
    fn Parser::parse_alter_sortkey(self : Parser, compound? : Bool) -> Expr? raise SqlglotError

    Parser::parse_alter_table_add

    source
    fn Parser::parse_alter_table_add(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_alter_table_alter

    source
    fn Parser::parse_alter_table_alter(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_table_alter_base

    source
    fn Parser::parse_alter_table_alter_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_table_drop

    source
    fn Parser::parse_alter_table_drop(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_alter_table_rename

    source
    fn Parser::parse_alter_table_rename(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_table_rename_base

    source
    fn Parser::parse_alter_table_rename_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_table_set

    source
    fn Parser::parse_alter_table_set(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_alter_table_set_base

    source
    fn Parser::parse_alter_table_set_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze

    source
    fn Parser::parse_analyze(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze_columns

    source
    fn Parser::parse_analyze_columns(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze_delete

    source
    fn Parser::parse_analyze_delete(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze_histogram

    source
    fn Parser::parse_analyze_histogram(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze_list

    source
    fn Parser::parse_analyze_list(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze_statistics

    source
    fn Parser::parse_analyze_statistics(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_analyze_validate

    source
    fn Parser::parse_analyze_validate(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_as_command

    source
    fn Parser::parse_as_command(self : Parser, start : Token) -> Expr

    Parser::parse_assignment

    source
    fn Parser::parse_assignment(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_assignment_base

    source
    fn Parser::parse_assignment_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_at_time_zone

    source
    fn Parser::parse_at_time_zone(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_atom

    source
    fn Parser::parse_atom(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_auto_increment

    source
    fn Parser::parse_auto_increment(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_auto_property

    source
    fn Parser::parse_auto_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_batch_statements

    source
    fn Parser::parse_batch_statements(self : Parser, parse_method : (Parser) -> Expr? raise SqlglotError, sep_first_statement? : Bool) -> Array[Expr?] raise SqlglotError

    Parser::parse_between

    source
    fn Parser::parse_between(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_binary_level

    source
    fn Parser::parse_binary_level(self : Parser, table : Map[TokenType, Kind], next : () -> Expr? raise SqlglotError) -> Expr? raise SqlglotError

    Parses a left-associative binary operator level.

    Parser::parse_bitwise

    source
    fn Parser::parse_bitwise(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_block

    source
    fn Parser::parse_block(self : Parser) -> Expr raise SqlglotError

    Parser::parse_blockcompression

    source
    fn Parser::parse_blockcompression(self : Parser) -> Expr raise SqlglotError

    Parser::parse_boolean

    source
    fn Parser::parse_boolean(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_bracket

    source
    fn Parser::parse_bracket(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_bracket_base

    source
    fn Parser::parse_bracket_base(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_bracket_key_value

    source
    fn Parser::parse_bracket_key_value(self : Parser, is_map? : Bool) -> Expr? raise SqlglotError

    Parser::parse_cache

    source
    fn Parser::parse_cache(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_called_on_null_input_property

    source
    fn Parser::parse_called_on_null_input_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_case

    source
    fn Parser::parse_case(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_cast

    source
    fn Parser::parse_cast(self : Parser, strict : Bool, safe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_ceil_floor

    source
    fn Parser::parse_ceil_floor(self : Parser, kind : Kind) -> Expr? raise SqlglotError

    Parser::parse_changes

    source
    fn Parser::parse_changes(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_char

    source
    fn Parser::parse_char(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_character_set

    source
    fn Parser::parse_character_set(self : Parser, default? : Bool) -> Expr raise SqlglotError

    Parser::parse_charset_name

    source
    fn Parser::parse_charset_name(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_check_constraint

    source
    fn Parser::parse_check_constraint(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_check_constraint_base

    source
    fn Parser::parse_check_constraint_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_checksum

    source
    fn Parser::parse_checksum(self : Parser) -> Expr raise SqlglotError

    Parser::parse_cluster

    source
    fn Parser::parse_cluster(self : Parser) -> Expr raise SqlglotError

    Parser::parse_cluster_property

    source
    fn Parser::parse_cluster_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_cluster_property_base

    source
    fn Parser::parse_cluster_property_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_clustered_by

    source
    fn Parser::parse_clustered_by(self : Parser) -> Expr raise SqlglotError

    Parser::parse_colon_as_variant_extract

    source
    fn Parser::parse_colon_as_variant_extract(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_column

    source
    fn Parser::parse_column(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_column_base

    source
    fn Parser::parse_column_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_column_constraint

    source
    fn Parser::parse_column_constraint(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_column_constraint_base

    source
    fn Parser::parse_column_constraint_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_column_def

    source
    fn Parser::parse_column_def(self : Parser, this : Expr?, computed_column? : Bool) -> Expr? raise SqlglotError

    Parser::parse_column_def_base

    source
    fn Parser::parse_column_def_base(self : Parser, this : Expr?, computed_column? : Bool) -> Expr? raise SqlglotError

    Parser::parse_column_def_with_exists

    source
    fn Parser::parse_column_def_with_exists(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_column_ops

    source
    fn Parser::parse_column_ops(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_column_ops_base

    source
    fn Parser::parse_column_ops_base(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_column_parts_fast

    source
    fn Parser::parse_column_parts_fast(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_column_reference

    source
    fn Parser::parse_column_reference(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_command

    source
    fn Parser::parse_command(self : Parser) -> Expr raise SqlglotError

    Parser::parse_comment

    source
    fn Parser::parse_comment(self : Parser, allow_exists? : Bool) -> Expr? raise SqlglotError

    Parser::parse_commit_or_rollback

    source
    fn Parser::parse_commit_or_rollback(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_commit_or_rollback_base

    source
    fn Parser::parse_commit_or_rollback_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_comparison

    source
    fn Parser::parse_comparison(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_composite_key_property

    source
    fn Parser::parse_composite_key_property(self : Parser, kind : Kind) -> Expr raise SqlglotError

    Parser::parse_comprehension

    source
    fn Parser::parse_comprehension(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_compress

    source
    fn Parser::parse_compress(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_condition

    source
    fn Parser::parse_condition(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_conjunction

    source
    fn Parser::parse_conjunction(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_connect

    source
    fn Parser::parse_connect(self : Parser, skip_start_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_connect_with_prior

    source
    fn Parser::parse_connect_with_prior(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_connect_with_prior_base

    source
    fn Parser::parse_connect_with_prior_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_connector_function

    source
    fn Parser::parse_connector_function(self : Parser, connector : Kind) -> Expr? raise SqlglotError

    Parser::parse_constraint

    source
    fn Parser::parse_constraint(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_constraint_base

    source
    fn Parser::parse_constraint_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_contains_property

    source
    fn Parser::parse_contains_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_convert

    source
    fn Parser::parse_convert(self : Parser, strict : Bool, safe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_convert_base

    source
    fn Parser::parse_convert_base(self : Parser, strict : Bool, safe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_copy

    source
    fn Parser::parse_copy(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_copy_parameters

    source
    fn Parser::parse_copy_parameters(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_copy_property

    source
    fn Parser::parse_copy_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_create

    source
    fn Parser::parse_create(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_create_base

    source
    fn Parser::parse_create_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_create_like

    source
    fn Parser::parse_create_like(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_credentials

    source
    fn Parser::parse_credentials(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_csv

    source
    fn Parser::parse_csv(self : Parser, parse_method : () -> Expr? raise SqlglotError, sep? : TokenType) -> Array[Expr] raise SqlglotError

    Parses a comma (or sep) separated list.

    Parser::parse_csv_any

    source
    fn[T] Parser::parse_csv_any(self : Parser, parse_method : () -> T? raise SqlglotError, sep? : TokenType) -> Array[T] raise SqlglotError

    _parse_csv for methods that don't return expressions.

    Parser::parse_cte

    source
    fn Parser::parse_cte(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_cte_base

    source
    fn Parser::parse_cte_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_cube_or_rollup

    source
    fn Parser::parse_cube_or_rollup(self : Parser, with_prefix? : Bool) -> Expr? raise SqlglotError

    Parser::parse_data_deletion_property

    source
    fn Parser::parse_data_deletion_property(self : Parser) -> Expr raise SqlglotError

    Parser::parse_datablocksize

    source
    fn Parser::parse_datablocksize(self : Parser, default? : Bool, minimum? : Bool, maximum? : Bool) -> Expr raise SqlglotError

    Parser::parse_dcolon

    source
    fn Parser::parse_dcolon(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_ddl_select

    source
    fn Parser::parse_ddl_select(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_declare

    source
    fn Parser::parse_declare(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_declareitem

    source
    fn Parser::parse_declareitem(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_decode

    source
    fn Parser::parse_decode(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_definer

    source
    fn Parser::parse_definer(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_definer_base

    source
    fn Parser::parse_definer_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_delete

    source
    fn Parser::parse_delete(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_derived_table_values

    source
    fn Parser::parse_derived_table_values(self : Parser, allow_value_synonym? : Bool) -> Expr? raise SqlglotError

    Parser::parse_describe

    source
    fn Parser::parse_describe(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_describe_base

    source
    fn Parser::parse_describe_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_dict_property

    source
    fn Parser::parse_dict_property(self : Parser, this : String) -> Expr? raise SqlglotError

    Parser::parse_dict_range

    source
    fn Parser::parse_dict_range(self : Parser, this : String) -> Expr? raise SqlglotError

    Parser::parse_disjunction

    source
    fn Parser::parse_disjunction(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_distinct_arg_function

    source
    fn Parser::parse_distinct_arg_function(self : Parser, kind : Kind, distinct_index? : Int) -> Expr? raise SqlglotError

    Parser::parse_distkey

    source
    fn Parser::parse_distkey(self : Parser) -> Expr raise SqlglotError

    Parser::parse_distributed_property

    source
    fn Parser::parse_distributed_property(self : Parser) -> Expr raise SqlglotError

    Parser::parse_drop

    source
    fn Parser::parse_drop(self : Parser, exists? : Bool) -> Expr? raise SqlglotError

    Parser::parse_drop_column

    source
    fn Parser::parse_drop_column(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_drop_column_base

    source
    fn Parser::parse_drop_column_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_drop_partition

    source
    fn Parser::parse_drop_partition(self : Parser, exists? : Bool?) -> Expr? raise SqlglotError

    Parser::parse_equality

    source
    fn Parser::parse_equality(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_escape

    source
    fn Parser::parse_escape(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_exists

    source
    fn Parser::parse_exists(self : Parser, not_? : Bool) -> Bool? raise SqlglotError

    IF [NOT] EXISTS. Returns None when IF isn't matched (Python None).

    Parser::parse_exponent

    source
    fn Parser::parse_exponent(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_expression

    source
    fn Parser::parse_expression(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_expressions

    source
    fn Parser::parse_expressions(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_extract

    source
    fn Parser::parse_extract(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_extract_base

    source
    fn Parser::parse_extract_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_factor

    source
    fn Parser::parse_factor(self : Parser, parse_mod? : Bool) -> Expr? raise SqlglotError

    Parser::parse_factor_operand

    source
    fn Parser::parse_factor_operand(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_fallback

    source
    fn Parser::parse_fallback(self : Parser, no? : Bool) -> Expr raise SqlglotError

    Parser::parse_field

    source
    fn Parser::parse_field(self : Parser, any_token? : Bool, tokens? : TokenSet, anonymous_func? : Bool) -> Expr? raise SqlglotError

    Parser::parse_field_def

    source
    fn Parser::parse_field_def(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_file_location

    source
    fn Parser::parse_file_location(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_foreign_key

    source
    fn Parser::parse_foreign_key(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_foreign_key_base

    source
    fn Parser::parse_foreign_key_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_format_json

    source
    fn Parser::parse_format_json(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_format_name

    source
    fn Parser::parse_format_name(self : Parser) -> Expr raise SqlglotError

    Parser::parse_freespace

    source
    fn Parser::parse_freespace(self : Parser) -> Expr raise SqlglotError

    Parser::parse_from

    source
    fn Parser::parse_from(self : Parser, joins? : Bool, skip_from_token? : Bool, consume_pipe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_from_base

    source
    fn Parser::parse_from_base(self : Parser, joins? : Bool, skip_from_token? : Bool, consume_pipe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_function

    source
    fn Parser::parse_function(self : Parser, functions? : Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError], anonymous? : Bool, optional_parens? : Bool, any_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_function_args

    source
    fn Parser::parse_function_args(self : Parser, alias? : Bool) -> Array[Expr] raise SqlglotError

    Parser::parse_function_base

    source
    fn Parser::parse_function_base(self : Parser, functions? : Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError], anonymous? : Bool, optional_parens? : Bool, any_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_function_call

    source
    fn Parser::parse_function_call(self : Parser, functions? : Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError], anonymous? : Bool, optional_parens? : Bool, any_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_function_call_base

    source
    fn Parser::parse_function_call_base(self : Parser, functions? : Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError], anonymous? : Bool, optional_parens? : Bool, any_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_function_parameter

    source
    fn Parser::parse_function_parameter(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_function_properties

    source
    fn Parser::parse_function_properties(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_function_properties_base

    source
    fn Parser::parse_function_properties_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_gap_fill

    source
    fn Parser::parse_gap_fill(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_generated_as_identity

    source
    fn Parser::parse_generated_as_identity(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_generated_as_identity_base

    source
    fn Parser::parse_generated_as_identity_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_grant

    source
    fn Parser::parse_grant(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_grant_principal

    source
    fn Parser::parse_grant_principal(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_grant_privilege

    source
    fn Parser::parse_grant_privilege(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_grant_revoke_common

    source
    fn Parser::parse_grant_revoke_common(self : Parser) -> (Array[Expr], String?, Expr?) raise SqlglotError

    Parser::parse_group

    source
    fn Parser::parse_group(self : Parser, skip_group_by_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_group_concat

    source
    fn Parser::parse_group_concat(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_group_concat_base

    source
    fn Parser::parse_group_concat_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_grouping_set

    source
    fn Parser::parse_grouping_set(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_grouping_sets

    source
    fn Parser::parse_grouping_sets(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_having

    source
    fn Parser::parse_having(self : Parser, skip_having_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_having_max

    source
    fn Parser::parse_having_max(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_heredoc

    source
    fn Parser::parse_heredoc(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_hint

    source
    fn Parser::parse_hint(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_hint_body

    source
    fn Parser::parse_hint_body(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_hint_fallback_to_string

    source
    fn Parser::parse_hint_fallback_to_string(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_hint_function_call

    source
    fn Parser::parse_hint_function_call(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_historical_data

    source
    fn Parser::parse_historical_data(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_id_var

    source
    fn Parser::parse_id_var(self : Parser, any_token? : Bool, tokens? : TokenSet) -> Expr? raise SqlglotError

    Parser::parse_id_var_base

    source
    fn Parser::parse_id_var_base(self : Parser, any_token? : Bool, tokens? : TokenSet) -> Expr? raise SqlglotError

    Parser::parse_identifier

    source
    fn Parser::parse_identifier(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_if

    source
    fn Parser::parse_if(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_if_base

    source
    fn Parser::parse_if_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_in

    source
    fn Parser::parse_in(self : Parser, this : Expr?, alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_index

    source
    fn Parser::parse_index(self : Parser, index? : Expr?, anonymous? : Bool) -> Expr? raise SqlglotError

    Parser::parse_index_params

    source
    fn Parser::parse_index_params(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_index_params_base

    source
    fn Parser::parse_index_params_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_indexed_column

    source
    fn Parser::parse_indexed_column(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_initcap

    source
    fn Parser::parse_initcap(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_inline

    source
    fn Parser::parse_inline(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_insert

    source
    fn Parser::parse_insert(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_insert_table

    source
    fn Parser::parse_insert_table(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_insert_table_base

    source
    fn Parser::parse_insert_table_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_interpolate

    source
    fn Parser::parse_interpolate(self : Parser) -> Array[Expr]? raise SqlglotError

    Parser::parse_interval

    source
    fn Parser::parse_interval(self : Parser, require_interval? : Bool, parse_function_unit? : Bool) -> Expr? raise SqlglotError

    Parser::parse_interval_span

    source
    fn Parser::parse_interval_span(self : Parser, this : Expr?, parse_function_unit? : Bool) -> Expr raise SqlglotError

    Parser::parse_into

    source
    fn Parser::parse_into(self : Parser, expression_types : ArrayView[Kind], raw_tokens : Array[Token], sql? : String, into_is_list? : Bool) -> Array[Expr?] raise SqlglotError

    Parses a list of tokens into a given Expr type.

    Parser::parse_into_clause

    source
    fn Parser::parse_into_clause(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_into_clause_base

    source
    fn Parser::parse_into_clause_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_introducer

    source
    fn Parser::parse_introducer(self : Parser, token : Token) -> Expr? raise SqlglotError

    Parser::parse_is

    source
    fn Parser::parse_is(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_join

    source
    fn Parser::parse_join(self : Parser, skip_join_token? : Bool, parse_bracket? : Bool, alias_tokens? : TokenSet) -> Expr? raise SqlglotError

    Parser::parse_join_base

    source
    fn Parser::parse_join_base(self : Parser, skip_join_token? : Bool, parse_bracket? : Bool, alias_tokens? : TokenSet) -> Expr? raise SqlglotError

    Parser::parse_join_hint

    source
    fn Parser::parse_join_hint(self : Parser, func_name : String) -> Expr? raise SqlglotError

    Parser::parse_join_parts

    source
    fn Parser::parse_join_parts(self : Parser) -> (Token?, Token?, Token?) raise SqlglotError

    Parser::parse_join_parts_base

    source
    fn Parser::parse_join_parts_base(self : Parser) -> (Token?, Token?, Token?)

    Parser::parse_joins

    source
    fn Parser::parse_joins(self : Parser, alias_tokens? : TokenSet) -> Array[Expr] raise SqlglotError

    Parser::parse_journal

    source
    fn Parser::parse_journal(self : Parser, kwargs : Map[String, Bool]) -> Expr raise SqlglotError

    Parser::parse_json_column_def

    source
    fn Parser::parse_json_column_def(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_json_key_value

    source
    fn Parser::parse_json_key_value(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_json_object

    source
    fn Parser::parse_json_object(self : Parser, agg? : Bool) -> Expr? raise SqlglotError

    Parser::parse_json_object_base

    source
    fn Parser::parse_json_object_base(self : Parser, agg? : Bool) -> Expr? raise SqlglotError

    Parser::parse_json_schema

    source
    fn Parser::parse_json_schema(self : Parser) -> Expr raise SqlglotError

    Parser::parse_json_table

    source
    fn Parser::parse_json_table(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_json_type_arg

    source
    fn Parser::parse_json_type_arg(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_json_value

    source
    fn Parser::parse_json_value(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_key_constraint_options

    source
    fn Parser::parse_key_constraint_options(self : Parser) -> Array[String] raise SqlglotError

    Parser::parse_key_value_property

    source
    fn Parser::parse_key_value_property(self : Parser, parse_value? : () -> Expr? raise SqlglotError) -> Expr? raise SqlglotError

    Parser::parse_kill

    source
    fn Parser::parse_kill(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_lambda

    source
    fn Parser::parse_lambda(self : Parser, alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_lambda_arg

    source
    fn Parser::parse_lambda_arg(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_lambda_base

    source
    fn Parser::parse_lambda_base(self : Parser, alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_lateral

    source
    fn Parser::parse_lateral(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_lateral_base

    source
    fn Parser::parse_lateral_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_limit

    source
    fn Parser::parse_limit(self : Parser, this? : Expr?, top? : Bool, skip_limit_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_limit_by

    source
    fn Parser::parse_limit_by(self : Parser) -> Array[Expr]? raise SqlglotError

    Parser::parse_limit_options

    source
    fn Parser::parse_limit_options(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_load

    source
    fn Parser::parse_load(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_locking

    source
    fn Parser::parse_locking(self : Parser) -> Expr raise SqlglotError

    Parser::parse_locks

    source
    fn Parser::parse_locks(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_log

    source
    fn Parser::parse_log(self : Parser, no? : Bool) -> Expr raise SqlglotError

    Parser::parse_macro_overloads

    source
    fn Parser::parse_macro_overloads(self : Parser, this : Expr, first_body : Expr, first_is_table : Bool) -> Expr? raise SqlglotError

    Parser::parse_match_against

    source
    fn Parser::parse_match_against(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_match_recognize

    source
    fn Parser::parse_match_recognize(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_match_recognize_measure

    source
    fn Parser::parse_match_recognize_measure(self : Parser) -> Expr raise SqlglotError

    Parser::parse_merge

    source
    fn Parser::parse_merge(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_mergeblockratio

    source
    fn Parser::parse_mergeblockratio(self : Parser, no? : Bool, default? : Bool) -> Expr raise SqlglotError

    Parser::parse_modifies_property

    source
    fn Parser::parse_modifies_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_multitable_inserts

    source
    fn Parser::parse_multitable_inserts(self : Parser, comments : Array[String]) -> Expr raise SqlglotError

    Parser::parse_name_as_expression

    source
    fn Parser::parse_name_as_expression(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_named_window

    source
    fn Parser::parse_named_window(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_next_value_for

    source
    fn Parser::parse_next_value_for(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_no_property

    source
    fn Parser::parse_no_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_normalize

    source
    fn Parser::parse_normalize(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_not_constraint

    source
    fn Parser::parse_not_constraint(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_null

    source
    fn Parser::parse_null(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_number

    source
    fn Parser::parse_number(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_odbc_datetime_literal

    source
    fn Parser::parse_odbc_datetime_literal(self : Parser) -> Expr raise SqlglotError

    Parser::parse_offset

    source
    fn Parser::parse_offset(self : Parser, this? : Expr?) -> Expr? raise SqlglotError

    Parser::parse_on_condition

    source
    fn Parser::parse_on_condition(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_on_conflict

    source
    fn Parser::parse_on_conflict(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_on_handling

    source
    fn Parser::parse_on_handling(self : Parser, on : String, values : Array[String]) -> Value? raise SqlglotError

    Parses "X ON Y" or "DEFAULT ON Y". Returns a string or an expression.

    Parser::parse_on_property

    source
    fn Parser::parse_on_property(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_on_property_base

    source
    fn Parser::parse_on_property_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_opclass

    source
    fn Parser::parse_opclass(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_open_json

    source
    fn Parser::parse_open_json(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_operator

    source
    fn Parser::parse_operator(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_order

    source
    fn Parser::parse_order(self : Parser, this? : Expr?, skip_order_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_ordered

    source
    fn Parser::parse_ordered(self : Parser, parse_method? : () -> Expr? raise SqlglotError) -> Expr? raise SqlglotError

    Parser::parse_ordered_base

    source
    fn Parser::parse_ordered_base(self : Parser, parse_method? : () -> Expr? raise SqlglotError) -> Expr? raise SqlglotError

    Parser::parse_overlay

    source
    fn Parser::parse_overlay(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_parameter

    source
    fn Parser::parse_parameter(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_paren

    source
    fn Parser::parse_paren(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_partition

    source
    fn Parser::parse_partition(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_partition_and_order

    source
    fn Parser::parse_partition_and_order(self : Parser) -> (Array[Expr], Expr?) raise SqlglotError

    Parser::parse_partition_base

    source
    fn Parser::parse_partition_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_partition_bound_spec

    source
    fn Parser::parse_partition_bound_spec(self : Parser) -> Expr raise SqlglotError

    Parser::parse_partition_by

    source
    fn Parser::parse_partition_by(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_partitioned_by

    source
    fn Parser::parse_partitioned_by(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_partitioned_by_base

    source
    fn Parser::parse_partitioned_by_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_partitioned_by_bucket_or_truncate

    source
    fn Parser::parse_partitioned_by_bucket_or_truncate(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_partitioned_of

    source
    fn Parser::parse_partitioned_of(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_period_for_system_time

    source
    fn Parser::parse_period_for_system_time(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_aggregate

    source
    fn Parser::parse_pipe_syntax_aggregate(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_aggregate_fields

    source
    fn Parser::parse_pipe_syntax_aggregate_fields(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_aggregate_group_order_by

    source
    fn Parser::parse_pipe_syntax_aggregate_group_order_by(self : Parser, query : Expr, group_by_exists? : Bool) -> Expr raise SqlglotError

    Parser::parse_pipe_syntax_extend

    source
    fn Parser::parse_pipe_syntax_extend(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_join

    source
    fn Parser::parse_pipe_syntax_join(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_limit

    source
    fn Parser::parse_pipe_syntax_limit(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_pivot

    source
    fn Parser::parse_pipe_syntax_pivot(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_query

    source
    fn Parser::parse_pipe_syntax_query(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_select

    source
    fn Parser::parse_pipe_syntax_select(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_set_operator

    source
    fn Parser::parse_pipe_syntax_set_operator(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pipe_syntax_tablesample

    source
    fn Parser::parse_pipe_syntax_tablesample(self : Parser, query : Expr) -> Expr? raise SqlglotError

    Parser::parse_pivot

    source
    fn Parser::parse_pivot(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_pivot_aggregation

    source
    fn Parser::parse_pivot_aggregation(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_pivot_aggregation_base

    source
    fn Parser::parse_pivot_aggregation_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_pivot_in

    source
    fn Parser::parse_pivot_in(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_pivots

    source
    fn Parser::parse_pivots(self : Parser) -> Array[Expr]? raise SqlglotError

    Parser::parse_placeholder

    source
    fn Parser::parse_placeholder(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_position

    source
    fn Parser::parse_position(self : Parser, haystack_first? : Bool) -> Expr? raise SqlglotError

    Parser::parse_position_base

    source
    fn Parser::parse_position_base(self : Parser, haystack_first? : Bool) -> Expr? raise SqlglotError

    Parser::parse_prewhere

    source
    fn Parser::parse_prewhere(self : Parser, skip_where_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_primary

    source
    fn Parser::parse_primary(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_primary_base

    source
    fn Parser::parse_primary_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_primary_key

    source
    fn Parser::parse_primary_key(self : Parser, wrapped_optional? : Bool, in_props? : Bool, named_primary_key? : Bool) -> Expr? raise SqlglotError

    Parser::parse_primary_key_base

    source
    fn Parser::parse_primary_key_base(self : Parser, wrapped_optional? : Bool, in_props? : Bool, named_primary_key? : Bool) -> Expr? raise SqlglotError

    Parser::parse_primary_key_part

    source
    fn Parser::parse_primary_key_part(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_primary_or_var

    source
    fn Parser::parse_primary_or_var(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_procedure_option

    source
    fn Parser::parse_procedure_option(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_projections

    source
    fn Parser::parse_projections(self : Parser) -> (Array[Expr], Array[Expr]?) raise SqlglotError

    Parser::parse_properties

    source
    fn Parser::parse_properties(self : Parser, before? : Bool) -> Expr? raise SqlglotError

    Parser::parse_property

    source
    fn Parser::parse_property(self : Parser) -> Value? raise SqlglotError

    Parser::parse_property_assignment

    source
    fn Parser::parse_property_assignment(self : Parser, kind : Kind, kwargs? : ArrayView[(String, &IntoValue)]) -> Expr raise SqlglotError

    Parser::parse_property_before

    source
    fn Parser::parse_property_before(self : Parser) -> Value? raise SqlglotError

    Parser::parse_property_before_base

    source
    fn Parser::parse_property_before_base(self : Parser) -> Value? raise SqlglotError

    Parser::parse_qualify

    source
    fn Parser::parse_qualify(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_query_modifiers

    source
    fn Parser::parse_query_modifiers(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_range

    source
    fn Parser::parse_range(self : Parser, this? : Expr?) -> Expr? raise SqlglotError

    Parser::parse_range_base

    source
    fn Parser::parse_range_base(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_reads_property

    source
    fn Parser::parse_reads_property(self : Parser) -> Expr? raise SqlglotError

    fn Parser::parse_recursive_with_search(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_references

    source
    fn Parser::parse_references(self : Parser, match_? : Bool) -> Expr? raise SqlglotError

    Parser::parse_refresh

    source
    fn Parser::parse_refresh(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_remote_with_connection

    source
    fn Parser::parse_remote_with_connection(self : Parser) -> Expr raise SqlglotError

    Parser::parse_respect_or_ignore_nulls

    source
    fn Parser::parse_respect_or_ignore_nulls(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_retention_period

    source
    fn Parser::parse_retention_period(self : Parser) -> Expr raise SqlglotError

    Parser::parse_returning

    source
    fn Parser::parse_returning(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_returns

    source
    fn Parser::parse_returns(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_returns_base

    source
    fn Parser::parse_returns_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_revoke

    source
    fn Parser::parse_revoke(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_row

    source
    fn Parser::parse_row(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_row_format

    source
    fn Parser::parse_row_format(self : Parser, match_row? : Bool) -> Expr? raise SqlglotError

    Parser::parse_schema

    source
    fn Parser::parse_schema(self : Parser, this? : Expr?) -> Expr? raise SqlglotError

    Parser::parse_select

    source
    fn Parser::parse_select(self : Parser, nested? : Bool, table? : Bool, parse_subquery_alias? : Bool, parse_set_operation? : Bool, consume_pipe? : Bool, from_? : Expr) -> Expr? raise SqlglotError

    Parser::parse_select_or_expression

    source
    fn Parser::parse_select_or_expression(self : Parser, alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_select_query

    source
    fn Parser::parse_select_query(self : Parser, nested? : Bool, table? : Bool, parse_subquery_alias? : Bool, parse_set_operation? : Bool) -> Expr? raise SqlglotError

    Parser::parse_sequence_properties

    source
    fn Parser::parse_sequence_properties(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_serde_properties

    source
    fn Parser::parse_serde_properties(self : Parser, with_? : Bool) -> Expr? raise SqlglotError

    Parser::parse_session_parameter

    source
    fn Parser::parse_session_parameter(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_set

    source
    fn Parser::parse_set(self : Parser, unset? : Bool, tag? : Bool) -> Expr? raise SqlglotError

    Parser::parse_set_base

    source
    fn Parser::parse_set_base(self : Parser, unset? : Bool, tag? : Bool) -> Expr? raise SqlglotError

    Parser::parse_set_item

    source
    fn Parser::parse_set_item(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_set_item_assignment

    source
    fn Parser::parse_set_item_assignment(self : Parser, kind? : String) -> Expr? raise SqlglotError

    Parser::parse_set_operation

    source
    fn Parser::parse_set_operation(self : Parser, this : Expr?, consume_pipe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_set_operations

    source
    fn Parser::parse_set_operations(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_set_transaction

    source
    fn Parser::parse_set_transaction(self : Parser, global_? : Bool) -> Expr raise SqlglotError

    Parser::parse_settings_property

    source
    fn Parser::parse_settings_property(self : Parser) -> Expr raise SqlglotError

    Parser::parse_show

    source
    fn Parser::parse_show(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_simplified_pivot

    source
    fn Parser::parse_simplified_pivot(self : Parser, is_unpivot? : Bool) -> Expr? raise SqlglotError

    Parser::parse_slice

    source
    fn Parser::parse_slice(self : Parser, this : Expr?) -> Expr? raise SqlglotError

    Parser::parse_sort

    source
    fn Parser::parse_sort(self : Parser, kind : Kind, token : TokenType) -> Expr? raise SqlglotError

    Parser::parse_sortkey

    source
    fn Parser::parse_sortkey(self : Parser, compound? : Bool) -> Expr raise SqlglotError

    Parser::parse_sql_security

    source
    fn Parser::parse_sql_security(self : Parser) -> Expr raise SqlglotError

    Parser::parse_star

    source
    fn Parser::parse_star(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_star_op

    source
    fn Parser::parse_star_op(self : Parser, keywords : ArrayView[String]) -> Array[Expr]? raise SqlglotError

    Parser::parse_star_ops

    source
    fn Parser::parse_star_ops(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_statement

    source
    fn Parser::parse_statement(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_statement_base

    source
    fn Parser::parse_statement_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_stored

    source
    fn Parser::parse_stored(self : Parser) -> Expr raise SqlglotError

    Parser::parse_stream

    source
    fn Parser::parse_stream(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_string

    source
    fn Parser::parse_string(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_string_agg

    source
    fn Parser::parse_string_agg(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_string_as_identifier

    source
    fn Parser::parse_string_as_identifier(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_struct_types

    source
    fn Parser::parse_struct_types(self : Parser, type_required? : Bool) -> Expr? raise SqlglotError

    Parser::parse_struct_types_base

    source
    fn Parser::parse_struct_types_base(self : Parser, type_required? : Bool) -> Expr? raise SqlglotError

    Parser::parse_subquery

    source
    fn Parser::parse_subquery(self : Parser, this : Expr?, parse_alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_substring

    source
    fn Parser::parse_substring(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_substring_base

    source
    fn Parser::parse_substring_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_system_versioning_property

    source
    fn Parser::parse_system_versioning_property(self : Parser, with_? : Bool) -> Expr raise SqlglotError

    Parser::parse_table

    source
    fn Parser::parse_table(self : Parser, schema? : Bool, joins? : Bool, alias_tokens? : TokenSet, parse_bracket? : Bool, is_db_reference? : Bool, parse_partition? : Bool, consume_pipe? : Bool) -> Expr? raise SqlglotError

    Parser::parse_table_alias

    source
    fn Parser::parse_table_alias(self : Parser, alias_tokens? : TokenSet) -> Expr? raise SqlglotError

    Parser::parse_table_base

    source
    fn Parser::parse_table_base(self : Parser, args : TableArgs) -> Expr? raise SqlglotError

    Parser::parse_table_hints

    source
    fn Parser::parse_table_hints(self : Parser) -> Array[Expr]? raise SqlglotError

    Parser::parse_table_hints_base

    source
    fn Parser::parse_table_hints_base(self : Parser) -> Array[Expr]? raise SqlglotError

    Parser::parse_table_part

    source
    fn Parser::parse_table_part(self : Parser, schema? : Bool) -> Expr? raise SqlglotError

    Parser::parse_table_part_base

    source
    fn Parser::parse_table_part_base(self : Parser, schema? : Bool) -> Expr? raise SqlglotError

    Parser::parse_table_parts

    source
    fn Parser::parse_table_parts(self : Parser, schema? : Bool, is_db_reference? : Bool, wildcard? : Bool, fast? : Bool) -> Expr? raise SqlglotError

    Parser::parse_table_parts_base

    source
    fn Parser::parse_table_parts_base(self : Parser, schema? : Bool, is_db_reference? : Bool, wildcard? : Bool, fast? : Bool) -> Expr? raise SqlglotError

    Parser::parse_table_parts_fast

    source
    fn Parser::parse_table_parts_fast(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_table_sample

    source
    fn Parser::parse_table_sample(self : Parser, as_modifier? : Bool) -> Expr? raise SqlglotError

    Parser::parse_table_sample_base

    source
    fn Parser::parse_table_sample_base(self : Parser, as_modifier? : Bool) -> Expr? raise SqlglotError

    Parser::parse_term

    source
    fn Parser::parse_term(self : Parser, parse_mod? : Bool) -> Expr? raise SqlglotError

    Parser::parse_to_table

    source
    fn Parser::parse_to_table(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_tokens_with

    source
    fn Parser::parse_tokens_with(self : Parser, parse_method : (Parser) -> Expr? raise SqlglotError, raw_tokens : Array[Token], sql : String) -> Array[Expr?] raise SqlglotError

    Parser::parse_transaction

    source
    fn Parser::parse_transaction(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_transaction_base

    source
    fn Parser::parse_transaction_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_trigger_deferrable

    source
    fn Parser::parse_trigger_deferrable(self : Parser) -> (String?, String?) raise SqlglotError

    Parser::parse_trigger_events

    source
    fn Parser::parse_trigger_events(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_trigger_execute

    source
    fn Parser::parse_trigger_execute(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_trigger_for_each

    source
    fn Parser::parse_trigger_for_each(self : Parser) -> String? raise SqlglotError

    Parser::parse_trigger_referencing

    source
    fn Parser::parse_trigger_referencing(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_trigger_referencing_clause

    source
    fn Parser::parse_trigger_referencing_clause(self : Parser, keyword : String) -> Expr? raise SqlglotError

    Parser::parse_trim

    source
    fn Parser::parse_trim(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_truncate_table

    source
    fn Parser::parse_truncate_table(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_ttl

    source
    fn Parser::parse_ttl(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_type

    source
    fn Parser::parse_type(self : Parser, parse_interval? : Bool, fallback_to_identifier? : Bool) -> Expr? raise SqlglotError

    Parser::parse_type_base

    source
    fn Parser::parse_type_base(self : Parser, parse_interval? : Bool, fallback_to_identifier? : Bool) -> Expr? raise SqlglotError

    Parser::parse_type_size

    source
    fn Parser::parse_type_size(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_types

    source
    fn Parser::parse_types(self : Parser, check_func? : Bool, schema? : Bool, allow_identifiers? : Bool, with_collation? : Bool) -> Expr? raise SqlglotError

    Parser::parse_types_base

    source
    fn Parser::parse_types_base(self : Parser, check_func? : Bool, schema? : Bool, allow_identifiers? : Bool, with_collation? : Bool) -> Expr? raise SqlglotError

    Parser::parse_unary

    source
    fn Parser::parse_unary(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_uncache

    source
    fn Parser::parse_uncache(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_unique

    source
    fn Parser::parse_unique(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_unique_base

    source
    fn Parser::parse_unique_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_unique_key

    source
    fn Parser::parse_unique_key(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_unique_key_base

    source
    fn Parser::parse_unique_key_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_unnamed_constraint

    source
    fn Parser::parse_unnamed_constraint(self : Parser, constraints? : 
    Set    [String]) -> Expr? raise SqlglotError

    Parser::parse_unnamed_constraints

    source
    fn Parser::parse_unnamed_constraints(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_unnest

    source
    fn Parser::parse_unnest(self : Parser, with_alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_unnest_base

    source
    fn Parser::parse_unnest_base(self : Parser, with_alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_unpivot_columns

    source
    fn Parser::parse_unpivot_columns(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_unquoted_field

    source
    fn Parser::parse_unquoted_field(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_update

    source
    fn Parser::parse_update(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_update_assignment

    source
    fn Parser::parse_update_assignment(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_update_base

    source
    fn Parser::parse_update_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_use

    source
    fn Parser::parse_use(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_use_base

    source
    fn Parser::parse_use_base(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_user_defined_function

    source
    fn Parser::parse_user_defined_function(self : Parser, kind? : TokenType) -> Expr? raise SqlglotError

    Parser::parse_user_defined_function_base

    source
    fn Parser::parse_user_defined_function_base(self : Parser, kind? : TokenType) -> Expr? raise SqlglotError

    Parser::parse_user_defined_function_expression

    source
    fn Parser::parse_user_defined_function_expression(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_user_defined_type

    source
    fn Parser::parse_user_defined_type(self : Parser, identifier : Expr) -> Expr? raise SqlglotError

    Parser::parse_user_defined_type_base

    source
    fn Parser::parse_user_defined_type_base(self : Parser, identifier : Expr) -> Expr? raise SqlglotError

    Parser::parse_using_identifiers

    source
    fn Parser::parse_using_identifiers(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_value

    source
    fn Parser::parse_value(self : Parser, values? : Bool) -> Expr? raise SqlglotError

    Parser::parse_value_base

    source
    fn Parser::parse_value_base(self : Parser, values? : Bool) -> Expr? raise SqlglotError

    Parser::parse_var

    source
    fn Parser::parse_var(self : Parser, any_token? : Bool, tokens? : TokenSet, upper? : Bool) -> Expr? raise SqlglotError

    Parser::parse_var_from_options

    source
    fn Parser::parse_var_from_options(self : Parser, options : Map[String, Array[Array[String]]], raise_unmatched? : Bool) -> Expr? raise SqlglotError

    Parser::parse_var_or_string

    source
    fn Parser::parse_var_or_string(self : Parser, upper? : Bool) -> Expr? raise SqlglotError

    Parser::parse_vector_expressions

    source
    fn Parser::parse_vector_expressions(self : Parser, expressions : Array[Expr]) -> Array[Expr] raise SqlglotError

    Parser::parse_version

    source
    fn Parser::parse_version(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_volatile_property

    source
    fn Parser::parse_volatile_property(self : Parser) -> Expr raise SqlglotError

    Parser::parse_when_matched

    source
    fn Parser::parse_when_matched(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_where

    source
    fn Parser::parse_where(self : Parser, skip_where_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_whileblock

    source
    fn Parser::parse_whileblock(self : Parser) -> Expr raise SqlglotError

    Parser::parse_window

    source
    fn Parser::parse_window(self : Parser, this : Expr?, alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_window_base

    source
    fn Parser::parse_window_base(self : Parser, this : Expr?, alias? : Bool) -> Expr? raise SqlglotError

    Parser::parse_window_clause

    source
    fn Parser::parse_window_clause(self : Parser) -> Array[Expr]? raise SqlglotError

    Parser::parse_window_spec

    source
    fn Parser::parse_window_spec(self : Parser) -> (Value?, String?) raise SqlglotError

    Returns (value, side).

    Parser::parse_with

    source
    fn Parser::parse_with(self : Parser, skip_with_token? : Bool) -> Expr? raise SqlglotError

    Parser::parse_with_operator

    source
    fn Parser::parse_with_operator(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_with_property

    source
    fn Parser::parse_with_property(self : Parser) -> Value? raise SqlglotError

    Parser::parse_with_property_base

    source
    fn Parser::parse_with_property_base(self : Parser) -> Value? raise SqlglotError

    Parser::parse_withdata

    source
    fn Parser::parse_withdata(self : Parser, no? : Bool) -> Expr raise SqlglotError

    Parser::parse_withisolatedloading

    source
    fn Parser::parse_withisolatedloading(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_withjournaltable

    source
    fn Parser::parse_withjournaltable(self : Parser) -> Expr raise SqlglotError

    Parser::parse_wrapped

    source
    fn[T] Parser::parse_wrapped(self : Parser, parse_method : () -> T raise SqlglotError, optional? : Bool) -> T raise SqlglotError

    Parser::parse_wrapped_csv

    source
    fn Parser::parse_wrapped_csv(self : Parser, parse_method : () -> Expr? raise SqlglotError, sep? : TokenType, optional? : Bool) -> Array[Expr] raise SqlglotError

    Parser::parse_wrapped_id_vars

    source
    fn Parser::parse_wrapped_id_vars(self : Parser, optional? : Bool) -> Array[Expr] raise SqlglotError

    Parser::parse_wrapped_options

    source
    fn Parser::parse_wrapped_options(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_wrapped_properties

    source
    fn Parser::parse_wrapped_properties(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_wrapped_select

    source
    fn Parser::parse_wrapped_select(self : Parser, table? : Bool) -> Expr? raise SqlglotError

    Parser::parse_wrapped_select_base

    source
    fn Parser::parse_wrapped_select_base(self : Parser, table? : Bool) -> Expr? raise SqlglotError

    Parser::parse_xml_element

    source
    fn Parser::parse_xml_element(self : Parser) -> Expr? raise SqlglotError

    Parser::parse_xml_namespace

    source
    fn Parser::parse_xml_namespace(self : Parser) -> Array[Expr] raise SqlglotError

    Parser::parse_xml_table

    source
    fn Parser::parse_xml_table(self : Parser) -> Expr? raise SqlglotError

    Parser::pivot_column_names

    source
    fn Parser::pivot_column_names(self : Parser, aggregations : Array[Expr]) -> Array[String] raise SqlglotError

    Parser::prev_upper

    source
    fn Parser::prev_upper(self : Parser) -> String

    Parser::raise_error

    source
    fn Parser::raise_error(self : Parser, message : String, token? : Token) -> Unit raise SqlglotError

    Appends an error in the list of recorded errors or raises it, depending on the chosen error level setting.

    Parser::replace_lambda

    source
    fn Parser::replace_lambda(self : Parser, node : Expr?, expressions : Array[Expr]) -> Expr? raise SqlglotError

    Parser::reset

    source
    fn Parser::reset(self : Parser) -> Unit

    Parser::retreat

    source
    fn Parser::retreat(self : Parser, index : Int) -> Unit

    Parser::sql_slice

    source
    fn Parser::sql_slice(self : Parser, start : Int, end : Int) -> String

    self.sql[start:end] (code point indices, Python slicing) in O(end - start): the code point -> UTF-16 offset table is built once per SQL string, instead of converting the whole string on every call.

    Parser::to_prop_eq

    source
    fn Parser::to_prop_eq(self : Parser, expression : Expr, index : Int) -> Expr raise SqlglotError

    Parser::try_parse

    source
    fn[T] Parser::try_parse(self : Parser, parse_method : () -> T? raise SqlglotError, retreat? : Bool) -> T?

    Attempts to backtrack if a parse function that contains a try/catch internally raises an error.

    Parser::validate_expression

    source
    fn Parser::validate_expression(self : Parser, expression : Expr, nargs? : Int) -> Expr raise SqlglotError

    Validates an Expr, making sure that all its mandatory arguments are set.

    Parser::values_to_select

    source
    fn Parser::values_to_select(self : Parser, values : Expr) -> Expr

    Parser::warn_unsupported

    source
    fn Parser::warn_unsupported(self : Parser) -> Unit

    ParserConfig

    source
    pub(all) struct ParserConfig {
      add_constraint_tokens : TokenSet
      add_join_on_true : Bool
      adjacent_strings_cannot_be_connected : Bool
      aggregate_type_tokens : TokenSet
      alias_tokens : TokenSet
      alterables : TokenSet
      alter_rename_requires_column : Bool
      alter_table_partitions : Bool
      ambiguous_alias_tokens : Array[TokenType]
      analyze_styles : 
    Set    [String]
      array_constructors : Map[String, Kind]
      assignment : Map[TokenType, Kind]
      bitwise : Map[TokenType, Kind]
      brackets : TokenSet
      cast_actions : Map[String, Array[Array[String]]]
      cast_column_operators : TokenSet
      clone_keywords : 
    Set    [String]
      colon_chain_is_single_extract : Bool
      colon_is_variant_extract : Bool
      colon_placeholder_tokens : TokenSet
      column_postfix_tokens : TokenSet
      comment_table_alias_tokens : TokenSet
      comparison : Map[TokenType, Kind]
      conflict_actions : Map[String, Array[Array[String]]]
      conjunction : Map[TokenType, Kind]
      copy_into_varlen_options : 
    Set    [String]
      creatables : TokenSet
      create_sequence : Map[String, Array[Array[String]]]
      db_creatables : TokenSet
      ddl_select_tokens : TokenSet
      default_sampling_method : String?
      describe_styles : 
    Set    [String]
      disjunction : Map[TokenType, Kind]
      distinct_tokens : TokenSet
      enum_type_tokens : TokenSet
      equality : Map[TokenType, Kind]
      execute_as_options : Map[String, Array[Array[String]]]
      exponent : Map[TokenType, Kind]
      factor : Map[TokenType, Kind]
      fetch_tokens : TokenSet
      functions_with_aliased_args : 
    Set    [String]
      func_tokens : TokenSet
      historical_data_kind : 
    Set    [String]
      historical_data_prefix : 
    Set    [String]
      identifier_tokens : TokenSet
      identify_pivot_strings : Bool
      id_var_tokens : TokenSet
      insert_alternatives : 
    Set    [String]
      interval_spans : Bool
      invalid_func_name_tokens : TokenSet
      isolated_loading_options : Map[String, Array[Array[String]]]
      is_json_predicate_kind : 
    Set    [String]
      joins_have_equal_precedence : Bool
      join_hints : 
    Set    [String]
      join_kinds : TokenSet
      join_methods : TokenSet
      join_sides : TokenSet
      json_arrows_require_json_type : Bool
      json_extract_requires_json_expression : Bool
      json_key_value_separator_tokens : TokenSet
      key_constraint_options : Map[String, Array[Array[String]]]
      key_value_definitions : Array[Kind]
      lambda_arg_terminators : TokenSet
      log_defaults_to_ln : Bool
      map_keys_are_arbitrary_expressions : Bool
      modifiables : Array[Kind]
      modifiers_attached_to_set_op : Bool
      nested_type_tokens : TokenSet
      no_paren_functions : Map[TokenType, Kind]
      no_paren_if_commands : Bool
      odbc_datetime_literals : Map[String, Kind]
      on_condition_tokens : 
    Set    [String]
      opclass_follow_keywords : 
    Set    [String]
      operation_modifiers : 
    Set    [String]
      optional_alias_token_cte : Bool
      optype_follow_tokens : TokenSet
      partition_keywords : 
    Set    [String]
      pivot_column_naming : String
      prefixed_pivot_columns : Bool
      pre_volatile_tokens : TokenSet
      privilege_follow_tokens : TokenSet
      procedure_options : Map[String, Array[Array[String]]]
      query_modifier_tokens : TokenSet
      quoted_types_to_preserve : 
    Set    [String]
      recursive_cte_search_kind : 
    Set    [String]
      reserved_tokens : TokenSet
      schema_binding_options : Map[String, Array[Array[String]]]
      schema_unnamed_constraints : 
    Set    [String]
      security_property_keywords : 
    Set    [String]
      select_start_tokens : TokenSet
      set_assignment_delimiters : 
    Set    [String]
      set_operations : TokenSet
      set_op_modifiers : 
    Set    [String]
      set_requires_assignment_delimiter : Bool
      signed_to_unsigned_type_token : Map[TokenType, TokenType]
      strict_cast : Bool
      string_aliases : Bool
      struct_type_tokens : TokenSet
      subquery_predicates : Map[TokenType, Kind]
      subquery_tokens : TokenSet
      supports_digit_prefixed_field_names : Bool
      supports_implicit_unnest : Bool
      supports_nth_value_from_modifier : Bool
      supports_omitted_interval_span_unit : Bool
      supports_partition_selection : Bool
      tablesample_csv : Bool
      table_alias_tokens : TokenSet
      table_index_hint_tokens : TokenSet
      table_postfix_tokens : TokenSet
      table_terminators : TokenSet
      term : Map[TokenType, Kind]
      text_match_excluded_tokens : TokenSet
      times : TokenSet
      timestamps : TokenSet
      transaction_characteristics : Map[String, Array[Array[String]]]
      transaction_kind : 
    Set    [String]
      trigger_deferrable : Map[String, Array[Array[String]]]
      trigger_events : TokenSet
      trigger_timing : Map[String, Array[Array[String]]]
      trim_pattern_first : Bool
      trim_types : 
    Set    [String]
      typed_lambda_args : Bool
      type_tokens : TokenSet
      unnest_offset_alias_tokens : TokenSet
      unpivot_value_columns_first : Bool
      update_alias_tokens : TokenSet
      usables : Map[String, Array[Array[String]]]
      values_followed_by_paren : Bool
      version_phrases : Array[(Array[String], String)]
      view_attributes : 
    Set    [String]
      window_alias_tokens : TokenSet
      window_before_paren_tokens : TokenSet
      window_exclude_options : Map[String, Array[Array[String]]]
      window_sides : 
    Set    [String]
      wrapped_transform_column_constraint : Bool
      zone_aware_timestamp_constructor : Bool
    }

    Data attributes of the Python Parser class.

    ParserConfig::copy

    source

    ParserFns

    source
    pub(all) struct ParserFns {
      functions : Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError]
      function_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      no_paren_function_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      statement_parsers : Map[TokenType, (Parser) -> Expr? raise SqlglotError]
      unary_parsers : Map[TokenType, (Parser) -> Expr? raise SqlglotError]
      string_parsers : Map[TokenType, (Parser, Token) -> Expr? raise SqlglotError]
      numeric_parsers : Map[TokenType, (Parser, Token) -> Expr? raise SqlglotError]
      primary_parsers : Map[TokenType, (Parser, Token) -> Expr? raise SqlglotError]
      placeholder_parsers : Map[TokenType, (Parser) -> Expr? raise SqlglotError]
      range_parsers : Map[TokenType, (Parser, Expr?) -> Expr? raise SqlglotError]
      column_operators : Map[TokenType, (Parser, Expr?, Expr?) -> Expr? raise SqlglotError?]
      json_operators : Map[TokenType, (Parser, Expr?, Expr?) -> Expr? raise SqlglotError]
      lambdas : Map[TokenType, (Parser, Array[Expr]) -> Expr? raise SqlglotError]
      expression_parsers : Map[Kind, (Parser) -> Expr? raise SqlglotError]
      property_parsers : Map[String, (Parser, Map[String, Bool]) -> Value? raise SqlglotError]
      constraint_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      alter_parsers : Map[String, (Parser) -> Value? raise SqlglotError]
      alter_alter_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      query_modifier_parsers : Map[TokenType, (Parser) -> (String, Value?) raise SqlglotError]
      set_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      show_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      type_literal_parsers : Map[DType, (Parser, Expr, Expr) -> Expr raise SqlglotError]
      type_converters : Map[DType, (Expr) -> Expr]
      pipe_syntax_transform_parsers : Map[String, (Parser, Expr) -> Expr? raise SqlglotError]
      analyze_expression_parsers : Map[String, (Parser) -> Expr? raise SqlglotError]
      hooks : ParserHooks
      show_trie : WordTrie
      set_trie : WordTrie
    }

    ParserFns::copy

    source
    fn ParserFns::copy(self : ParserFns) -> ParserFns

    ParserFns::finalize

    source
    fn ParserFns::finalize(self : ParserFns) -> Unit

    Recomputes SHOW_TRIE / SET_TRIE.

    ParserHooks

    source
    pub(all) struct ParserHooks {
      negate_range : (Parser, Expr?) -> Expr? raise SqlglotError?
      parse_alias : (Parser, Expr?, Bool) -> Expr? raise SqlglotError?
      parse_alter_drop_action : (Parser) -> Expr? raise SqlglotError?
      parse_alter_table_alter : (Parser) -> Expr? raise SqlglotError?
      parse_alter_table_rename : (Parser) -> Expr? raise SqlglotError?
      parse_alter_table_set : (Parser) -> Expr? raise SqlglotError?
      parse_assignment : (Parser) -> Expr? raise SqlglotError?
      parse_bracket : (Parser, Expr?) -> Expr? raise SqlglotError?
      parse_bracket_key_value : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_charset_name : (Parser) -> Expr? raise SqlglotError?
      parse_check_constraint : (Parser) -> Expr? raise SqlglotError?
      parse_cluster_property : (Parser) -> Expr? raise SqlglotError?
      parse_column : (Parser) -> Expr? raise SqlglotError?
      parse_column_constraint : (Parser) -> Expr? raise SqlglotError?
      parse_column_def : (Parser, Expr?, Bool) -> Expr? raise SqlglotError?
      parse_column_ops : (Parser, Expr?) -> Expr? raise SqlglotError?
      parse_commit_or_rollback : (Parser) -> Expr? raise SqlglotError?
      parse_connect_with_prior : (Parser) -> Expr? raise SqlglotError?
      parse_constraint : (Parser) -> Expr? raise SqlglotError?
      parse_convert : (Parser, Bool, Bool?) -> Expr? raise SqlglotError?
      parse_create : (Parser) -> Expr? raise SqlglotError?
      parse_cte : (Parser) -> Expr? raise SqlglotError?
      parse_dcolon : (Parser) -> Expr? raise SqlglotError?
      parse_definer : (Parser) -> Expr? raise SqlglotError?
      parse_describe : (Parser) -> Expr? raise SqlglotError?
      parse_drop_column : (Parser) -> Expr? raise SqlglotError?
      parse_equality : (Parser) -> Expr? raise SqlglotError?
      parse_expression : (Parser) -> Expr? raise SqlglotError?
      parse_extract : (Parser) -> Expr? raise SqlglotError?
      parse_factor_operand : (Parser) -> Expr? raise SqlglotError?
      parse_file_location : (Parser) -> Expr? raise SqlglotError?
      parse_foreign_key : (Parser) -> Expr? raise SqlglotError?
      parse_from : (Parser, Bool, Bool, Bool) -> Expr? raise SqlglotError?
      parse_function : (Parser, Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError]?, Bool, Bool, Bool) -> Expr? raise SqlglotError?
      parse_function_call : (Parser, Map[String, (Array[Expr], Parser) -> Expr raise SqlglotError]?, Bool, Bool, Bool) -> Expr? raise SqlglotError?
      parse_function_parameter : (Parser) -> Expr? raise SqlglotError?
      parse_function_properties : (Parser) -> Expr? raise SqlglotError?
      parse_generated_as_identity : (Parser) -> Expr? raise SqlglotError?
      parse_group_concat : (Parser) -> Expr? raise SqlglotError?
      parse_hint_function_call : (Parser) -> Expr? raise SqlglotError?
      parse_id_var : (Parser, Bool, TokenSet?) -> Expr? raise SqlglotError?
      parse_if : (Parser) -> Expr? raise SqlglotError?
      parse_index_params : (Parser) -> Expr? raise SqlglotError?
      parse_insert_table : (Parser) -> Expr? raise SqlglotError?
      parse_into_clause : (Parser) -> Expr? raise SqlglotError?
      parse_join : (Parser, Bool, Bool, TokenSet?) -> Expr? raise SqlglotError?
      parse_join_parts : (Parser) -> (Token?, Token?, Token?) raise SqlglotError?
      parse_json_object : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_lambda : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_lambda_arg : (Parser) -> Expr? raise SqlglotError?
      parse_lateral : (Parser) -> Expr? raise SqlglotError?
      parse_on_property : (Parser) -> Expr? raise SqlglotError?
      parse_ordered : (Parser, () -> Expr? raise SqlglotError?) -> Expr? raise SqlglotError?
      parse_parameter : (Parser) -> Expr? raise SqlglotError?
      parse_partition : (Parser) -> Expr? raise SqlglotError?
      parse_partition_and_order : (Parser) -> (Array[Expr], Expr?) raise SqlglotError?
      parse_partitioned_by : (Parser) -> Expr? raise SqlglotError?
      parse_pivot_aggregation : (Parser) -> Expr? raise SqlglotError?
      parse_position : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_primary : (Parser) -> Expr? raise SqlglotError?
      parse_primary_key : (Parser, Bool, Bool, Bool) -> Expr? raise SqlglotError?
      parse_primary_key_part : (Parser) -> Expr? raise SqlglotError?
      parse_projections : (Parser) -> (Array[Expr], Array[Expr]?) raise SqlglotError?
      parse_property_before : (Parser) -> Value? raise SqlglotError?
      parse_range : (Parser, Expr?) -> Expr? raise SqlglotError?
      parse_returns : (Parser) -> Expr? raise SqlglotError?
      parse_set : (Parser, Bool, Bool) -> Expr? raise SqlglotError?
      parse_statement : (Parser) -> Expr? raise SqlglotError?
      parse_struct_types : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_substring : (Parser) -> Expr? raise SqlglotError?
      parse_table : (Parser, TableArgs) -> Expr? raise SqlglotError?
      parse_table_hints : (Parser) -> Array[Expr]? raise SqlglotError?
      parse_table_part : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_table_parts : (Parser, Bool, Bool, Bool, Bool) -> Expr? raise SqlglotError?
      parse_table_sample : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_transaction : (Parser) -> Expr? raise SqlglotError?
      parse_type : (Parser, Bool, Bool) -> Expr? raise SqlglotError?
      parse_types : (Parser, Bool, Bool, Bool, Bool) -> Expr? raise SqlglotError?
      parse_unique : (Parser) -> Expr? raise SqlglotError?
      parse_unique_key : (Parser) -> Expr? raise SqlglotError?
      parse_unnest : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_update : (Parser) -> Expr? raise SqlglotError?
      parse_use : (Parser) -> Expr? raise SqlglotError?
      parse_user_defined_function : (Parser, TokenType?) -> Expr? raise SqlglotError?
      parse_user_defined_function_expression : (Parser) -> Expr? raise SqlglotError?
      parse_user_defined_type : (Parser, Expr) -> Expr? raise SqlglotError?
      parse_value : (Parser, Bool) -> Expr? raise SqlglotError?
      parse_vector_expressions : (Parser, Array[Expr]) -> Array[Expr] raise SqlglotError?
      parse_window : (Parser, Expr?, Bool) -> Expr? raise SqlglotError?
      parse_with_property : (Parser) -> Value? raise SqlglotError?
      parse_wrapped_id_vars : (Parser, Bool) -> Array[Expr] raise SqlglotError?
      parse_wrapped_select : (Parser, Bool) -> Expr? raise SqlglotError?
      pivot_column_names : (Parser, Array[Expr]) -> Array[String] raise SqlglotError?
      to_prop_eq : (Parser, Expr, Int) -> Expr raise SqlglotError?
      build_cast : (Parser, Bool, Array[(String, Value?)]) -> Expr raise SqlglotError?
      parse : (Parser, Array[Token], String) -> Array[Expr?] raise SqlglotError?
      parse_into : (Parser, Array[Kind], Array[Token], String) -> Array[Expr?] raise SqlglotError?
    }

    ParserHooks::copy

    source
    fn ParserHooks::copy(self : ParserHooks) -> ParserHooks

    ParserHooks::new

    source

    PropertiesLocation

    source
    pub(all) enum PropertiesLocation {
      PostCreate
      PostName
      PostSchema
      PostWith
      PostAlias
      PostExpression
      PostIndex
      Unsupported
    } derive(Eq, Hash, 
    Debug    )

    Where a property is placed in a CREATE statement.

    PyObj

    source
    pub(all) enum PyObj {
      PyExpr(Expr)
      PyStr(String)
      PyInt(Int64)
      PyFloat(Double)
      PyDecimal(String)
      PyBool(Bool)
      PyNone
      PyTuple(Array[PyObj])
      PyList(Array[PyObj])
      PyDict(Array[(PyObj, PyObj)])
      PyBytes(Bytes)
      PyObject(Array[(String, PyObj)])
      PyDate(year~ : Int, month~ : Int, day~ : Int)
      PyTime(hour~ : Int, minute~ : Int, second~ : Int, microsecond~ : Int)
      PyDateTime(year~ : Int, month~ : Int, day~ : Int, hour~ : Int, minute~ : Int, second~ : Int, microsecond~ : Int, tz~ : (String, Int)?)
    } derive(Eq)

    A host value, mirroring the Python objects that sqlglot's builder API accepts (ExpOrStr, and the values understood by exp.convert).
    impl IntoPy for PyObj

    PyObj::py_repr

    source
    fn PyObj::py_repr(self : PyObj) -> String

    Python repr(value) for a host value.

    PyObj::py_str

    source
    fn PyObj::py_str(self : PyObj) -> String

    Python str(value) for a host value.

    PyObj::truthy

    source
    fn PyObj::truthy(self : PyObj) -> Bool

    Python truthiness of a host value.

    QuoteSpec

    source
    pub(all) enum QuoteSpec {
      Same(String)
      Pair(String, String)
    }

    A quote specification: either a symmetric delimiter or a (start, end) pair.

    StrOrBool

    source
    pub(all) enum StrOrBool {
      S(String)
      B(Bool)
    } derive(Eq, 
    Debug    )

    A Python attribute whose value is either a string or a boolean.

    TableArgs

    source
    pub(all) struct TableArgs {
      schema : Bool
      joins : Bool
      alias_tokens : TokenSet?
      parse_bracket : Bool
      is_db_reference : Bool
      parse_partition : Bool
      consume_pipe : Bool
    }

    Keyword arguments of _parse_table.

    Token

    source
    pub struct Token {
      token_type : TokenType
      text : String
      line : Int
      col : Int
      start : Int
      end : Int
      comments : Array[String]
    }

    A lexical token.
    impl Show for Token

    Token::identifier

    source
    fn Token::identifier(s : String) -> Token

    Token::new

    source
    fn Token::new(token_type : TokenType, text : String, line? : Int, col? : Int, start? : Int, end? : Int, comments? : Array[String]) -> Token

    Token::number

    source
    fn Token::number(n : Int) -> Token

    Token::ok

    source
    fn Token::ok(self : Token) -> Bool

    Python truthiness of a token (Token.__bool__).

    Token::string

    source
    fn Token::string(s : String) -> Token

    Token::var_

    source
    fn Token::var_(s : String) -> Token

    TokenSet

    source
    pub struct TokenSet {
      bits : FixedArray[Bool]
    }

    A set of token types (Python set[TokenType]), stored as a bitmap.

    TokenSet::add

    source
    fn TokenSet::add(self : TokenSet, t : TokenType) -> Unit

    Adds t in place.

    TokenSet::contains

    source
    fn TokenSet::contains(self : TokenSet, t : TokenType) -> Bool

    TokenSet::copy

    source
    fn TokenSet::copy(self : TokenSet) -> TokenSet

    TokenSet::empty

    source
    fn TokenSet::empty() -> TokenSet

    TokenSet::minus

    source
    fn TokenSet::minus(self : TokenSet, other : ArrayView[TokenType]) -> TokenSet

    Returns a new set: self - other.

    TokenSet::minus_set

    source
    fn TokenSet::minus_set(self : TokenSet, other : TokenSet) -> TokenSet

    Returns a new set: self - other.

    TokenSet::new

    source
    fn TokenSet::new(types : ArrayView[TokenType]) -> TokenSet

    TokenSet::remove

    source
    fn TokenSet::remove(self : TokenSet, t : TokenType) -> Unit

    Removes t in place.

    TokenSet::to_array

    source
    fn TokenSet::to_array(self : TokenSet) -> Array[TokenType]

    TokenSet::union

    source
    fn TokenSet::union(self : TokenSet, other : ArrayView[TokenType]) -> TokenSet

    Returns a new set: self | other.

    TokenSet::union_set

    source
    fn TokenSet::union_set(self : TokenSet, other : TokenSet) -> TokenSet

    Returns a new set: self | other.

    TokenType

    source
    pub(all) enum TokenType {
      L_PAREN
      R_PAREN
      L_BRACKET
      R_BRACKET
      L_BRACE
      R_BRACE
      COMMA
      DOT
      DASH
      PLUS
      COLON
      DOTCOLON
      DOTCARET
      DCOLON
      DCOLONDOLLAR
      DCOLONPERCENT
      DCOLONQMARK
      DQMARK
      SEMICOLON
      STAR
      BACKSLASH
      SLASH
      LT
      LTE
      GT
      GTE
      NOT
      EQ
      NEQ
      NULLSAFE_EQ
      COLON_EQ
      COLON_GT
      NCOLON_GT
      AND
      OR
      AMP
      DPIPE
      PIPE_GT
      PIPE
      PIPE_SLASH
      DPIPE_SLASH
      CARET
      CARET_AT
      TILDE
      ARROW
      DARROW
      FARROW
      HASH
      HASH_ARROW
      DHASH_ARROW
      LR_ARROW
      LLRR_ARROW
      DAT
      AT_QMARK
      LT_AT
      AT_GT
      DOLLAR
      PARAMETER
      SESSION
      SESSION_PARAMETER
      SESSION_USER
      DAMP
      AMP_LT
      AMP_GT
      ADJACENT
      XOR
      DSTAR
      QMARK_AMP
      QMARK_PIPE
      HASH_DASH
      EXCLAMATION
      URI_START
      BLOCK_START
      BLOCK_END
      SPACE
      BREAK
      STRING
      NUMBER
      IDENTIFIER
      DATABASE
      COLUMN
      COLUMN_DEF
      SCHEMA
      TABLE
      WAREHOUSE
      STAGE
      STREAM
      STREAMLIT
      VAR
      BIT_STRING
      HEX_STRING
      BYTE_STRING
      NATIONAL_STRING
      RAW_STRING
      HEREDOC_STRING
      UNICODE_STRING
      BIT
      BOOLEAN
      TINYINT
      UTINYINT
      SMALLINT
      USMALLINT
      MEDIUMINT
      UMEDIUMINT
      INT
      UINT
      BIGINT
      UBIGINT
      BIGNUM
      INT128
      UINT128
      INT256
      UINT256
      FLOAT
      DOUBLE
      UDOUBLE
      DECIMAL
      DECIMAL32
      DECIMAL64
      DECIMAL128
      DECIMAL256
      DECFLOAT
      UDECIMAL
      BIGDECIMAL
      CHAR
      NCHAR
      VARCHAR
      NVARCHAR
      BPCHAR
      TEXT
      MEDIUMTEXT
      LONGTEXT
      BLOB
      MEDIUMBLOB
      LONGBLOB
      TINYBLOB
      TINYTEXT
      NAME
      BINARY
      VARBINARY
      JSON
      JSONB
      TIME
      TIMETZ
      TIME_NS
      TIMESTAMP
      TIMESTAMPTZ
      TIMESTAMPLTZ
      TIMESTAMPNTZ
      TIMESTAMP_S
      TIMESTAMP_MS
      TIMESTAMP_NS
      DATETIME
      DATETIME2
      DATETIME64
      SMALLDATETIME
      DATE
      DATE32
      INT4RANGE
      INT4MULTIRANGE
      INT8RANGE
      INT8MULTIRANGE
      NUMRANGE
      NUMMULTIRANGE
      TSRANGE
      TSMULTIRANGE
      TSTZRANGE
      TSTZMULTIRANGE
      DATERANGE
      DATEMULTIRANGE
      UUID
      GEOGRAPHY
      GEOGRAPHYPOINT
      NULLABLE
      GEOMETRY
      POINT
      RING
      LINESTRING
      LOCALTIME
      LOCALTIMESTAMP
      SYSTIMESTAMP
      MULTILINESTRING
      POLYGON
      MULTIPOLYGON
      HLLSKETCH
      HSTORE
      SUPER
      SERIAL
      SMALLSERIAL
      BIGSERIAL
      XML
      YEAR
      USERDEFINED
      MONEY
      SMALLMONEY
      ROWVERSION
      IMAGE
      VARIANT
      OBJECT
      INET
      IPADDRESS
      IPPREFIX
      IPV4
      IPV6
      ENUM
      ENUM8
      ENUM16
      FIXEDSTRING
      LOWCARDINALITY
      NESTED
      AGGREGATEFUNCTION
      SIMPLEAGGREGATEFUNCTION
      TDIGEST
      UNKNOWN
      VECTOR
      DYNAMIC
      VOID
      ALIAS
      ALTER
      ALL
      ANTI
      ANY
      APPLY
      ARRAY
      ASC
      ASOF
      ATTACH
      AUTO_INCREMENT
      BEGIN
      BETWEEN
      BULK_COLLECT_INTO
      CACHE
      CASE
      CHARACTER_SET
      CLUSTER_BY
      COLLATE
      COMMAND
      COMMENT
      COMMIT
      CONNECT_BY
      CONSTRAINT
      COPY
      CREATE
      CROSS
      CUBE
      CURRENT_DATE
      CURRENT_DATETIME
      CURRENT_SCHEMA
      CURRENT_TIME
      CURRENT_TIMESTAMP
      CURRENT_USER
      CURRENT_USER_ID
      CURRENT_ROLE
      CURRENT_CATALOG
      DECLARE
      DEFAULT
      DELETE
      DESC
      DESCRIBE
      DETACH
      DICTIONARY
      DISTINCT
      DISTRIBUTE_BY
      DIV
      DROP
      ELSE
      END
      ESCAPE
      EXCEPT
      EXECUTE
      EXISTS
      FALSE
      FETCH
      FILE
      FILE_FORMAT
      FILTER
      FINAL
      FIRST
      FOR
      FORCE
      FOREIGN_KEY
      FORMAT
      FROM
      FULL
      FUNCTION
      GET
      GLOB
      GLOBAL
      GRANT
      GROUP_BY
      GROUPING_SETS
      HAVING
      HINT
      IGNORE
      ILIKE
      IN
      INDEX
      INDEXED_BY
      INNER
      INSERT
      INSTALL
      INTEGRATION
      INTERSECT
      INTERVAL
      INTO
      INTRODUCER
      IRLIKE
      IS
      ISNULL
      JOIN
      JOIN_MARKER
      KEEP
      KEY
      KILL
      LANGUAGE
      LATERAL
      LEFT
      LIKE
      LIMIT
      LIST
      LOAD
      LOCK
      MAP
      MATCH
      MATCH_CONDITION
      MATCH_RECOGNIZE
      MEMBER_OF
      MERGE
      MOD
      MODEL
      NATURAL
      NEXT
      NOTHING
      NOTNULL
      NULL
      OBJECT_IDENTIFIER
      OFFSET
      ON
      ONLY
      OPERATOR
      ORDER_BY
      ORDER_SIBLINGS_BY
      ORDERED
      ORDINALITY
      OUT
      INOUT
      OUTER
      OVER
      OVERLAPS
      OVERWRITE
      PACKAGE
      PARTITION
      PARTITION_BY
      PERCENT
      PIVOT
      PLACEHOLDER
      POLICY
      POOL
      POSITIONAL
      PRAGMA
      PREWHERE
      PRIMARY_KEY
      PROCEDURE
      PROPERTIES
      PROJECTION
      PSEUDO_TYPE
      PUT
      QUALIFY
      QUOTE
      QDCOLON
      RANGE
      RECURSIVE
      REFRESH
      RENAME
      REPLACE
      RETURNING
      REVOKE
      REFERENCES
      RIGHT
      RLIKE
      ROLE
      ROLLBACK
      ROLLUP
      ROW
      ROWS
      RULE
      SELECT
      SEMI
      SEPARATOR
      SEQUENCE
      SERDE_PROPERTIES
      SET
      SETTINGS
      SHOW
      SIMILAR_TO
      SOME
      SORT_BY
      SOUNDS_LIKE
      SQL_SECURITY
      START_WITH
      STORAGE_INTEGRATION
      STRAIGHT_JOIN
      STRUCT
      SUMMARIZE
      TABLE_SAMPLE
      TAG
      TEMPORARY
      TOP
      THEN
      TRUE
      TRUNCATE
      TRIGGER
      TYPE
      UNCACHE
      UNDROP
      UNION
      UNNEST
      UNPIVOT
      UPDATE
      USE
      USING
      VALUES
      VARIADIC
      VIEW
      SEMANTIC_VIEW
      VOLATILE
      VOLUME
      WHEN
      WHERE
      WINDOW
      WITH
      UNIQUE
      UTC_DATE
      UTC_TIME
      UTC_TIMESTAMP
      OPTION
      SINK
      SOURCE
      ANALYZE
      NAMESPACE
      EXPORT
      HIVE_TOKEN_STREAM
      SENTINEL
    } derive(Compare, Eq, Hash)

    impl Show for TokenType

    TokenType::id

    source
    fn TokenType::id(self : TokenType) -> Int

    TokenType::name

    source
    fn TokenType::name(self : TokenType) -> String

    Tokenizer

    source
    pub struct Tokenizer {
      settings : TokenizerSettings
      numbers_can_be_underscore_separated : Bool
      identifiers_can_start_with_digit : Bool
      unescaped_sequences : Map[String, String]
      sql : Array[Char]
      sql_str : String
      size : Int
      tokens : Array[Token]
      start : Int
      current : Int
      line : Int
      col : Int
      comments : Array[String]
      char : Char
      end : Bool
      peek : Char
      prev_token_line : Int
    }

    Tokenizer state for a single tokenize call.

    Tokenizer::new

    source
    fn Tokenizer::new(settings : TokenizerSettings, numbers_can_be_underscore_separated? : Bool, identifiers_can_start_with_digit? : Bool, unescaped_sequences? : Map[String, String]) -> Tokenizer

    Tokenizer::tokenize

    source
    fn Tokenizer::tokenize(self : Tokenizer, sql : String) -> Array[Token] raise SqlglotError

    Returns a list of tokens corresponding to the SQL string sql.

    TokenizerSettings

    source
    pub(all) struct TokenizerSettings {
      single_tokens : Map[Char, TokenType]
      bit_strings : Array[QuoteSpec]
      byte_strings : Array[QuoteSpec]
      hex_strings : Array[QuoteSpec]
      raw_strings : Array[QuoteSpec]
      heredoc_strings : Array[QuoteSpec]
      unicode_strings : Array[QuoteSpec]
      identifiers : Array[QuoteSpec]
      quotes : Array[QuoteSpec]
      string_escapes : Array[String]
      byte_string_escapes : Array[String]?
      var_single_tokens : Array[Char]
      escape_follow_chars : Array[String]
      identifier_escapes : Array[String]
      heredoc_tag_is_identifier : Bool
      heredoc_string_alternative : TokenType
      string_escapes_allowed_in_raw_strings : Bool
      numeric_escapes : Map[String, NumericEscape]
      drop_unknown_escapes : Bool
      nested_comments : Bool
      hint_start : String
      tokens_preceding_hint : Array[TokenType]
      keywords : Map[String, TokenType]
      commands : Array[TokenType]
      command_prefix_tokens : Array[TokenType]
      numeric_literals : Map[String, String]
      numbers_can_have_decimals : Bool
      comments : Array[QuoteSpec]
      quotes_map : Map[String, String]
      identifiers_map : Map[String, String]
      identifier_chars : Map[Char, String]
      format_strings : Map[String, (String, TokenType)]
      string_escapes_set : Map[String, Bool]
      byte_string_escapes_set : Map[String, Bool]
      escape_follow_chars_set : Map[String, Bool]
      identifier_escapes_set : Map[String, Bool]
      comments_map : Map[String, String?]
      keyword_trie : Trie
      commands_set : Map[TokenType, Bool]
    }

    Tokenizer configuration of a dialect (the Python Tokenizer class attributes).

    TokenizerSettings::copy

    source

    TokenizerSettings::finalize

    source

    Computes the derived attributes (Python's __init_subclass__).

    Trie

    source
    pub struct Trie {
      children : Map[Char, Trie]
      terminal : Bool
    }

    A character trie, mirroring sqlglot.trie.

    Trie::add

    source
    fn Trie::add(self : Trie, key : String) -> Unit

    Trie::get

    source
    fn Trie::get(self : Trie, c : Char) -> Trie?

    Trie::new

    source
    fn Trie::new() -> Trie

    TrieResult

    source
    pub(all) enum TrieResult {
      Failed
      Prefix
      Exists
    } derive(Eq, 
    Debug    )

    Value

    source
    pub(all) enum Value {
      Node(Expr)
      List(Array[Value])
      Str(String)
      Bool(Bool)
      Int(Int64)
      DT(DType)
    }

    An argument value of an expression.
    impl IntoValue for Value
    impl SqlArg for Value

    Value::as_node

    source
    fn Value::as_node(self : Value) -> Expr?

    Value::as_str

    source
    fn Value::as_str(self : Value) -> String?

    Value::truthy

    source
    fn Value::truthy(self : Value) -> Bool

    Python truthiness of an argument value.

    WordTrie

    source
    pub struct WordTrie {
      children : Map[String, WordTrie]
      terminal : Bool
    }

    A trie keyed by words (Python new_trie(key.split(" ") for key in ...)).

    WordTrie::from_keys

    source
    fn WordTrie::from_keys(keys : Iter[String]) -> WordTrie

    WordTrie::lookup

    source
    fn WordTrie::lookup(self : WordTrie, key : ArrayView[String]) -> (TrieResult, WordTrie)

    Checks whether a single word continues from self.

    WordTrie::new

    source
    fn WordTrie::new() -> WordTrie

    add_

    source
    fn add_(a : Expr, b : Expr) -> Expr

    Python expr + other (Expr.__add__): Add with operands wrapped as needed.

    add_recursive_cte_column_names

    source
    fn add_recursive_cte_column_names(expression : Expr) -> Expr raise SqlglotError

    Uses projection output names in recursive CTE definitions to define the CTEs' columns.

    add_within_group_for_percentiles

    source
    fn add_within_group_for_percentiles(expression : Expr) -> Expr raise SqlglotError

    Transforms percentiles by adding a WITHIN GROUP clause to them.

    alias_

    source
    fn alias_(e : Expr, name : String, quoted? : Bool, copy? : Bool) -> Expr

    exp.alias_(expression, name) with a string alias.

    alias_expr

    source
    fn alias_expr(e : Expr, alias : Expr?, copy? : Bool) -> Expr

    exp.alias_(expression, alias) with an identifier alias expression.

    alias_table

    source
    fn alias_table(e : Expr, name : String, columns? : Array[String], copy? : Bool) -> Expr

    exp.alias_(expression, name, table=True)

    all_dtypes

    source
    let all_dtypes : FixedArray[DType]

    all_json_path_parts

    source
    let all_json_path_parts : Array[Kind]

    Python ALL_JSON_PATH_PARTS.

    all_kinds

    source
    let all_kinds : FixedArray[Kind]

    all_token_types

    source
    let all_token_types : FixedArray[TokenType]

    and_

    source
    fn and_(conditions : Array[Expr], copy? : Bool, wrap? : Bool) -> Expr

    exp.and_(...) for expressions (copied unless copy is false).

    annotate_types_hook

    source
    let annotate_types_hook : 
    Ref    [(Expr, Dialect) -> Expr raise SqlglotError?]

    any_to_exists

    source
    fn any_to_exists(expression : Expr) -> Expr raise SqlglotError

    Transform ANY operator to Spark's EXISTS.

    any_value_to_max_sql

    source
    fn any_value_to_max_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python any_value_to_max_sql.

    apply_index_offset

    source
    fn apply_index_offset(this : Expr, expressions : Array[Expr], offset : Int, dialect : Dialect) -> Array[Expr]

    exp.apply_index_offset

    apply_set_operation

    source
    fn apply_set_operation(expressions : Array[PyObj], kind : Kind, distinct? : Bool, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Python _apply_set_operation.

    approx_count_distinct_sql

    source
    fn approx_count_distinct_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python approx_count_distinct_sql.

    arg_max_or_min_no_count

    source
    fn arg_max_or_min_no_count(name : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python arg_max_or_min_no_count(name).

    array_

    source
    fn array_(expressions : Array[Expr], copy? : Bool) -> Expr

    exp.array(*expressions) (copied unless copy is false).

    array_append_sql

    source
    fn array_append_sql(name : String, swap_params? : Bool) -> ((Generator, Expr) -> String raise SqlglotError)

    Python array_append_sql(name, swap_params): transpiles ARRAY_APPEND/ARRAY_PREPEND between dialects with different NULL propagation semantics.

    array_compact_sql

    source
    fn array_compact_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python array_compact_sql.

    array_concat_sql

    source
    fn array_concat_sql(name : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python array_concat_sql(name): transpiles ARRAY_CONCAT/ARRAY_CAT between dialects with different NULL propagation semantics.

    arrow_json_extract_sql

    source
    fn arrow_json_extract_sql(g : Generator, e : Expr, op? : String) -> String raise SqlglotError

    Python arrow_json_extract_sql(self, expression, op=None).

    base_after_having_modifier_transforms

    source
    fn base_after_having_modifier_transforms() -> Array[(String, (Generator, Expr) -> String raise SqlglotError)]

    The base Generator's AFTER_HAVING_MODIFIER_TRANSFORMS.

    base_dialect

    source
    fn base_dialect() -> Dialect

    The base sqlglot dialect (cached).

    base_dialect_config

    source
    fn base_dialect_config() -> DialectConfig

    base_generator_config

    source
    fn base_generator_config() -> GeneratorConfig

    base_generator_fns

    source
    fn base_generator_fns() -> GeneratorFns

    The base Generator's TRANSFORMS and other callable tables.

    base_generator_transforms

    source
    fn base_generator_transforms() -> Map[Kind, (Generator, Expr) -> String raise SqlglotError]

    The base Generator's TRANSFORMS.

    base_jsonpath_tokenizer_settings_raw

    source
    fn base_jsonpath_tokenizer_settings_raw() -> TokenizerSettings

    base_parser_config

    source
    fn base_parser_config() -> ParserConfig

    base_parser_fns

    source
    fn base_parser_fns() -> ParserFns

    The base Parser's FUNCTIONS and *_PARSERS tables.

    base_tokenizer_settings_raw

    source
    fn base_tokenizer_settings_raw() -> TokenizerSettings

    binary_from_function

    source
    fn binary_from_function(kind : Kind) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python binary_from_function(expr_type).

    binary_range_parser

    source
    fn binary_range_parser(kind : Kind, reverse_args? : Bool) -> ((Parser, Expr?) -> Expr? raise SqlglotError)

    binary_range_parser(expr_type, reverse_args)

    bool_xor_sql

    source
    fn bool_xor_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python bool_xor_sql.

    boolean

    source
    fn boolean(b : Bool) -> Expr

    bracket_to_element_at_sql

    source
    fn bracket_to_element_at_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python bracket_to_element_at_sql.

    build_array_append

    source
    fn build_array_append(args : Array[Expr], p : Parser) -> Expr

    build_array_concat

    source
    fn build_array_concat(args : Array[Expr], p : Parser) -> Expr

    build_array_constructor

    source
    fn build_array_constructor(kind : Kind, args : Array[Expr], bracket_kind : TokenType, dialect : Dialect) -> Expr

    build_array_prepend

    source
    fn build_array_prepend(args : Array[Expr], p : Parser) -> Expr

    build_array_remove

    source
    fn build_array_remove(args : Array[Expr], p : Parser) -> Expr

    build_coalesce

    source
    fn build_coalesce(args : Array[Expr], is_nvl? : Bool, is_null? : Bool) -> Expr

    build_convert_timezone

    source
    fn build_convert_timezone(args : Array[Expr], default_source_tz? : String) -> Expr

    build_date_delta

    source
    fn build_date_delta(kind : Kind, unit_mapping? : Map[String, String], default_unit? : String, supports_timezone? : Bool) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python build_date_delta(exp_class, unit_mapping=None, default_unit="DAY",supports_timezone=False). Pass default_unit="" for Python None.

    build_date_delta_with_interval

    source
    fn build_date_delta_with_interval(kind : Kind, default_unit? : String) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python build_date_delta_with_interval(expression_class, default_unit=None). Python returns None for fewer than 2 arguments; this raises a ParseError instead.

    build_default_decimal_type

    source
    fn build_default_decimal_type(precision? : Int, scale? : Int) -> ((Expr) -> Expr)

    Python build_default_decimal_type(precision=None, scale=None): a DataType converter that adds default DECIMAL parameters.

    build_extract_json_with_path

    source
    fn build_extract_json_with_path(kind : Kind) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    build_formatted_time

    source
    fn build_formatted_time(kind : Kind, dialect_override? : String, default? : Bool, default_format? : String) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python build_formatted_time(exp_class, dialect_override=None, default=None).

    build_formatted_time_expr

    source
    fn build_formatted_time_expr(kind : Kind, args : Array[Expr], dialect : Dialect, dialect_override? : String, default? : Bool, default_format? : String) -> Expr raise SqlglotError

    Python build_formatted_time(exp_class, dialect_override, default)(args, dialect). default=true uses the dialect's TIME_FORMAT; default_format is a string default.

    build_hex

    source
    fn build_hex(args : Array[Expr], p : Parser) -> Expr

    build_json_extract_op

    source
    fn build_json_extract_op(p : Parser, this : Expr?, path : Expr?) -> Expr? raise SqlglotError

    JSON operator builders shared between COLUMN_OPERATORS and JSON_OPERATORS.

    build_json_extract_path

    source
    fn build_json_extract_path(kind : Kind, zero_based_indexing? : Bool, arrow_req_json_type? : Bool, json_type? : String) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python build_json_extract_path(expr_type, zero_based_indexing=True,arrow_req_json_type=False, json_type=None). Like Python, it truncates args to 2 elements when the path is built.

    build_json_extract_scalar_op

    source
    fn build_json_extract_scalar_op(p : Parser, this : Expr?, path : Expr?) -> Expr? raise SqlglotError

    build_jsonb_contains_top_key_op

    source
    fn build_jsonb_contains_top_key_op(p : Parser, this : Expr?, key : Expr?) -> Expr? raise SqlglotError

    build_jsonb_extract_op

    source
    fn build_jsonb_extract_op(p : Parser, this : Expr?, path : Expr?) -> Expr? raise SqlglotError

    build_jsonb_extract_scalar_op

    source
    fn build_jsonb_extract_scalar_op(p : Parser, this : Expr?, path : Expr?) -> Expr? raise SqlglotError

    build_like

    source
    fn build_like(args : Array[Expr]) -> Expr

    build_like_fn

    source
    fn build_like_fn(kind : Kind, not_like? : Bool) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python build_like(expr_type, not_like=False) from dialects/dialect.py (named build_like_fn because the parser's build_like(args) already exists).

    build_locate_strposition

    source
    fn build_locate_strposition(args : Array[Expr]) -> Expr

    build_logarithm

    source
    fn build_logarithm(args : Array[Expr], p : Parser) -> Expr

    build_lower

    source
    fn build_lower(args : Array[Expr]) -> Expr

    build_mod

    source
    fn build_mod(args : Array[Expr]) -> Expr

    build_pad

    source
    fn build_pad(args : Array[Expr], is_left? : Bool) -> Expr

    build_regexp_extract

    source
    fn build_regexp_extract(kind : Kind) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    Python build_regexp_extract(expr_type).

    build_replace_with_optional_replacement

    source
    fn build_replace_with_optional_replacement(args : Array[Expr]) -> Expr

    Python build_replace_with_optional_replacement(args).

    build_timestamp_from_parts

    source
    fn build_timestamp_from_parts(args : Array[Expr]) -> Expr

    Python build_timestamp_from_parts(args).

    build_timestamp_trunc

    source
    fn build_timestamp_trunc(args : Array[Expr]) -> Expr

    Python build_timestamp_trunc(args) (DATE_TRUNC in Doris, Postgres and StarRocks).

    build_timetostr_or_tochar

    source
    fn build_timetostr_or_tochar(args : Array[Expr], dialect : Dialect) -> Expr raise SqlglotError

    Python build_timetostr_or_tochar(args, dialect).

    build_trim

    source
    fn build_trim(args : Array[Expr], is_left? : Bool, reverse_args? : Bool) -> Expr

    build_trunc

    source
    fn build_trunc(args : Array[Expr], dialect : Dialect, date_trunc_unabbreviate? : Bool, default_date_trunc_unit? : String, date_trunc_requires_part? : Bool, fractions_supported? : Bool) -> Expr raise SqlglotError

    Python build_trunc(args, dialect, ...): builder for dialects with an overloaded TRUNC (Oracle, Snowflake, etc). Uses type annotation to distinguish date vs numeric truncation and returns Anonymous if the type cannot be determined.

    build_upper

    source
    fn build_upper(args : Array[Expr]) -> Expr

    build_var_map

    source
    fn build_var_map(args : Array[Expr]) -> Expr

    camel_to_snake_case

    source
    fn camel_to_snake_case(name : String) -> String

    Converts name from CamelCase to SNAKE_CASE (upper).

    case_

    source
    fn case_(this? : Expr) -> Expr

    exp.case() builder.

    case_else

    source
    fn case_else(case_ : Expr, value : Expr, copy? : Bool) -> Expr

    Python Case.else_(value, copy).

    case_when

    source
    fn case_when(case_ : Expr, condition : Expr, then : Expr, copy? : Bool) -> Expr

    Python Case.when(condition, then, copy).

    cast_

    source
    fn cast_(expression : Expr, to : DType, copy? : Bool) -> Expr

    exp.cast(expression, to) with a DType target. Avoids re-casting to the same type.

    cast_to

    source
    fn cast_to(expression : Expr, to : Expr, copy? : Bool) -> Expr

    exp.cast(expression, to) with a DataType expression target.

    cast_to_type

    source
    fn cast_to_type(expression : Expr, to : Expr) -> Expr

    exp.cast(expression, to, copy=False) for an already-built DataType.

    char_lower

    source
    fn char_lower(c : Char) -> Char

    The first code point of str(c).lower() (CPython's _PyUnicode_ToLowercase, which is also re's case-insensitive key _sre.unicode_tolower).

    char_upper

    source
    fn char_upper(c : Char) -> Char

    The first code point of str(c).upper() (CPython's _PyUnicode_ToUppercase).

    code_point_offsets

    source
    fn code_point_offsets(s : String) -> Array[Int]

    The UTF-16 offset of every code point of s, plus s.length() at the end; [] when s has no surrogate pairs (offsets equal code point indices).

    column_from_parts

    source
    fn column_from_parts(col : Expr, table? : Expr?, db? : Expr?, catalog? : Expr?, fields? : Array[Expr]) -> Expr

    exp.column(col, table, db, catalog, fields=...) with identifier expressions.

    column_of

    source
    fn column_of(name : String, table? : String, quoted? : Bool) -> Expr

    exp.column(name) for a simple (possibly quoted) column name.

    column_table_names

    source
    fn column_table_names(expression : Expr, exclude? : String) -> Array[String]

    exp.column_table_names(expression, exclude)

    combine_conditions

    source
    fn combine_conditions(conditions : Array[Expr], connector : Kind, copy? : Bool, wrap? : Bool) -> Expr

    Combines conditions with a connector (And / Or / Xor), wrapping operands that are themselves connectors in parentheses (Python _combine). As in Python, the conditions are copied unless copy is false.

    combine_py

    source
    fn combine_py(expressions : Array[PyObj], operator : Kind, dialect? : Dialect, copy? : Bool, wrap? : Bool) -> Expr raise SqlglotError

    Python _combine: parses the conditions and combines them with operator (And, Or or Xor), wrapping connector operands in parentheses when wrap is set.

    concat_messages

    source
    fn concat_messages(errors : Array[String], maximum : Int) -> String

    concat_to_dpipe_sql

    source
    fn concat_to_dpipe_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python concat_to_dpipe_sql (same as Generator::concat_to_dpipe_sql).

    concat_ws_to_dpipe_sql

    source
    fn concat_ws_to_dpipe_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python concat_ws_to_dpipe_sql.

    condition

    source
    fn[T : IntoPy] condition(expression : T, dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    Python exp.condition(expression): parses a logical condition.

    convert

    source
    fn[T : IntoPy] convert(value : T, copy? : Bool) -> Expr raise SqlglotError

    Python exp.convert: converts a host value into an expression. Raises ValueError when a conversion is not possible.

    count_if_to_sum

    source
    fn count_if_to_sum(g : Generator, e : Expr) -> String raise SqlglotError

    Python count_if_to_sum.

    csv

    source
    fn csv(args : Array[String], sep? : String) -> String

    sqlglot helper.csv: joins the non-empty strings with sep.

    ctas_with_tmp_tables_to_create_tmp_view

    source
    fn ctas_with_tmp_tables_to_create_tmp_view(tmp_storage_provider? : (Expr) -> Expr raise SqlglotError) -> ((Expr) -> Expr raise SqlglotError)

    datatype_build

    source
    fn datatype_build(dtype : DType, kwargs? : ArrayView[(String, &IntoValue)]) -> Expr

    DataType.build(dtype, **kwargs) for a DType.

    datatype_from_str

    source
    fn datatype_from_str(dtype : String, dialect? : Dialect, udt? : Bool) -> Expr raise SqlglotError

    Python DataType.from_str.

    datatype_is_type

    source
    fn datatype_is_type(dt : Expr, dtypes : ArrayView[DType]) -> Bool

    DataType.is_type(*dtypes) for plain DTypes.

    datatype_is_type_expr

    source
    fn datatype_is_type_expr(dt : Expr, other : Expr) -> Bool

    DataType.is_type(other) for a DataType expression other.

    datatype_of

    source
    fn datatype_of(dtype : DType) -> Expr

    DataType(this=dtype) (Python DType.into_expr() / DataType.build(dtype)).

    date_add_interval_sql

    source
    fn date_add_interval_sql(data_type : String, kind : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python date_add_interval_sql(data_type, kind): <data_type>_<kind>(this, INTERVAL ...).

    date_delta_sql

    source
    fn date_delta_sql(name : String, cast? : Bool) -> ((Generator, Expr) -> String raise SqlglotError)

    Python date_delta_sql(name, cast=False): name(unit, expression, this).

    date_delta_to_binary_interval_op

    source
    fn date_delta_to_binary_interval_op(cast? : Bool) -> ((Generator, Expr) -> String raise SqlglotError)

    Python date_delta_to_binary_interval_op(cast=True): this +/- INTERVAL ....

    date_trunc_to_time

    source
    fn date_trunc_to_time(args : Array[Expr]) -> Expr

    Python date_trunc_to_time(args).

    datestrtodate_sql

    source
    fn datestrtodate_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python datestrtodate_sql.

    decimal_value

    source
    fn decimal_value(c : Char) -> Int

    The value of a decimal digit (unicodedata.decimal), or -1.

    default_pretty

    source
    let default_pretty : 
    Ref    [Bool]

    Python's module-level sqlglot.pretty: the default for generators created without an explicit pretty option.

    dialect_class_name

    source
    fn dialect_class_name(d : Dialect) -> String

    Python Dialect.__class__.__name__ for a dialect.

    dialect_names

    source
    fn dialect_names() -> Array[String]

    Names of all registered dialects.

    div_

    source
    fn div_(a : Expr, b : Expr) -> Expr

    Python expr / other.

    dot_build

    source
    fn dot_build(expressions : Array[Expr]) -> Expr

    Dot.build(expressions)

    dtype_array_types

    source
    let dtype_array_types : Array[DType]

    dtype_binary_types

    source
    let dtype_binary_types : Array[DType]

    dtype_float_types

    source
    let dtype_float_types : Array[DType]

    dtype_from_name

    source
    fn dtype_from_name(name : String) -> DType?

    dtype_from_value

    source
    fn dtype_from_value(value : String) -> DType?

    dtype_integer_types

    source
    let dtype_integer_types : Array[DType]

    dtype_nested_types

    source
    let dtype_nested_types : Array[DType]

    dtype_numeric_types

    source
    let dtype_numeric_types : Array[DType]

    dtype_real_types

    source
    let dtype_real_types : Array[DType]

    dtype_signed_integer_types

    source
    let dtype_signed_integer_types : Array[DType]

    dtype_struct_types

    source
    let dtype_struct_types : Array[DType]

    dtype_temporal_types

    source
    let dtype_temporal_types : Array[DType]

    dtype_text_types

    source
    let dtype_text_types : Array[DType]

    dtype_unsigned_integer_types

    source
    let dtype_unsigned_integer_types : Array[DType]

    eliminate_distinct_on

    source
    fn eliminate_distinct_on(expression : Expr) -> Expr raise SqlglotError

    Convert SELECT DISTINCT ON statements to a subquery with a window function.

    eliminate_full_outer_join

    source
    fn eliminate_full_outer_join(expression : Expr) -> Expr raise SqlglotError

    Converts a query with a FULL OUTER join to a union of identical queries that use LEFT/RIGHT OUTER joins instead.

    eliminate_qualify

    source
    fn eliminate_qualify(expression : Expr) -> Expr raise SqlglotError

    Convert SELECT statements that contain the QUALIFY clause into subqueries.

    eliminate_semi_and_anti_joins

    source
    fn eliminate_semi_and_anti_joins(expression : Expr) -> Expr raise SqlglotError

    Convert SEMI and ANTI joins into equivalent forms that use EXIST instead.

    eliminate_window_clause

    source
    fn eliminate_window_clause(expression : Expr) -> Expr raise SqlglotError

    Eliminates the WINDOW query clause by inlining each named window.

    encode_decode_sql

    source
    fn encode_decode_sql(g : Generator, e : Expr, name : String, replace? : Bool) -> String raise SqlglotError

    Python encode_decode_sql(self, expression, name, replace=True). Used for dialects whose functions don't support a charset and assume utf-8.

    ends_with

    source
    fn ends_with(s : String, suffix : String) -> Bool

    ensure_bools

    source
    fn ensure_bools(expression : Expr) -> Expr

    Converts numeric values used in conditions into explicit boolean expressions (Python transforms.ensure_bools).

    epoch_cast_to_ts

    source
    fn epoch_cast_to_ts(expression : Expr) -> Expr raise SqlglotError

    Replace 'epoch' in casts by the equivalent date literal.

    exp_add

    source
    fn exp_add(this : Expr, other : Expr) -> Expr

    Python this + other.

    exp_alias

    source
    fn exp_alias(expression : Expr, alias_ : Value, quoted? : Bool, copy? : Bool) -> Expr raise SqlglotError

    Python alias_(expression, alias) with table=False.

    exp_and

    source
    fn exp_and(expressions : Array[Expr], copy? : Bool, wrap? : Bool) -> Expr

    Python and_(*expressions).

    exp_binop

    source
    fn exp_binop(kind : Kind, this : Expr, other : Expr) -> Expr

    Python Expr._binop(klass, other).

    exp_case

    source
    fn exp_case() -> Expr

    Python exp.case().

    exp_cast

    source
    fn exp_cast(expression : Expr, to : DType, copy? : Bool, dialect? : Dialect) -> Expr

    Python exp.cast(expression, dtype, copy, dialect) with a DType.

    exp_cast_to

    source
    fn exp_cast_to(expression : Expr, to : Expr, copy? : Bool, dialect? : Dialect) -> Expr

    Python exp.cast(expression, to, copy, dialect) with a DataType expression.

    exp_div

    source
    fn exp_div(this : Expr, other : Expr) -> Expr

    Python this / other.

    exp_eq

    source
    fn exp_eq(this : Expr, other : Expr) -> Expr

    Python this.eq(other).

    exp_is

    source
    fn exp_is(this : Expr, other : Expr) -> Expr

    Python this.is_(other).

    exp_neq

    source
    fn exp_neq(this : Expr, other : Expr) -> Expr

    Python this.neq(other).

    exp_not

    source
    fn exp_not(expression : Expr, copy? : Bool) -> Expr

    Python not_(expression, copy).

    exp_or

    source
    fn exp_or(expressions : Array[Expr], copy? : Bool, wrap? : Bool) -> Expr

    Python or_(*expressions).

    exp_paren

    source
    fn exp_paren(expression : Expr, copy? : Bool) -> Expr

    Python paren(expression, copy).

    exp_select_from

    source
    fn exp_select_from(projections : Array[Expr], from_expr : Expr) -> Expr

    Python exp.select(*projections).from_(from_expr, copy=False).

    exp_subquery_of

    source
    fn exp_subquery_of(query : Expr, alias_? : String, copy? : Bool) -> Expr

    Python Query.subquery(alias, copy).

    exp_subquery_with_alias_expr

    source
    fn exp_subquery_with_alias_expr(query : Expr, alias_ : Expr?, copy? : Bool) -> Expr

    Python Query.subquery(alias_expr, copy) where alias is already an expression.

    exp_table_from_identifier

    source
    fn exp_table_from_identifier(table : Expr?) -> Expr raise SqlglotError

    Python exp.table_(name) for an identifier expression.

    exp_union

    source
    fn exp_union(left : Expr, right : Expr, distinct? : Bool) -> Expr

    Python exp.union(left, right, distinct=distinct, copy=False).

    exp_wrap

    source
    fn exp_wrap(expression : Expr, kind : Kind) -> Expr

    Python _wrap(expression, kind): wraps in a Paren if it is a kind.

    explode_to_unnest_sql

    source
    fn explode_to_unnest_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python explode_to_unnest_sql (for Lateral).

    expr_or

    source
    fn expr_or(a : Expr?, b : () -> Expr? raise SqlglotError) -> Expr? raise SqlglotError

    Python a or b for optional expressions.

    expr_to_sql

    source
    fn expr_to_sql(expression : Expr) -> String raise SqlglotError

    Generates SQL for expression with the base dialect and default settings (Python str(expression) / expression.sql()).

    false_

    source
    fn false_() -> Expr

    filter_array_using_unnest

    source
    fn filter_array_using_unnest(g : Generator, e : Expr) -> String raise SqlglotError

    Python filter_array_using_unnest.

    find_all_in_scope

    source
    fn find_all_in_scope(expression : Expr, kinds : ArrayView[Kind]) -> Array[Expr]

    find_in_scope

    source
    fn find_in_scope(expression : Expr, kinds : ArrayView[Kind]) -> Expr?

    find_new_name

    source
    fn find_new_name(taken : (String) -> Bool, base : String) -> String

    Searches for a name that isn't in taken.

    find_tables

    source
    fn find_tables(expression : Expr) -> Array[Expr]

    exp.find_tables(expression)

    format_time

    source
    fn format_time(string : String, mapping : Map[String, String], trie : Trie) -> String

    format_time returning Python's str(None) for empty input, which is what exp.Literal.string(format_time(...)) produces.

    format_time_opt

    source
    fn format_time_opt(string : String, mapping : Map[String, String], trie? : Trie) -> String?

    Converts a time string given a mapping (Python format_time). Returns None for an empty string.

    from_arg_list

    source
    fn from_arg_list(kind : Kind, args : Array[Expr]) -> Expr

    Func.from_arg_list(args)

    from_arg_list_builder

    source
    fn from_arg_list_builder(kind : Kind) -> ((Array[Expr], Parser) -> Expr raise SqlglotError)

    A builder that calls from_arg_list.

    func_

    source
    fn func_(name : String, args : Array[Expr], dialect? : Dialect) -> Expr raise SqlglotError

    exp.func(name, *args): builds a known function via the dialect's FUNCTIONS, or an Anonymous function.

    function_by_name

    source
    let function_by_name : Array[(String, Kind)]

    exp.FUNCTION_BY_NAME: SQL function names to function kinds.

    gen_annotate_types

    source
    fn gen_annotate_types(expression : Expr, dialect : Dialect) -> Expr raise SqlglotError

    Annotates types using annotate_types_hook, or a minimal fallback that only types integer literals.

    gen_apply_index_offset

    source
    fn gen_apply_index_offset(this : Expr, expressions : Array[Expr], offset : Int, dialect : Dialect) -> Array[Expr] raise SqlglotError

    Python expressions.apply_index_offset.

    gen_find_all_in_scope

    source
    fn gen_find_all_in_scope(expression : Expr, kinds : ArrayView[Kind]) -> Array[Expr]

    Python optimizer.scope.find_all_in_scope.

    gen_map_date_part

    source
    fn gen_map_date_part(part : Expr?, dialect : Dialect) -> Expr?

    Python dialects.dialect.map_date_part.

    gen_unit_to_str

    source
    fn gen_unit_to_str(expression : Expr, default? : String) -> Expr?

    Python dialects.dialect.unit_to_str.

    gen_walk_in_scope

    source
    fn gen_walk_in_scope(expression : Expr, out : Array[Expr]) -> Unit

    Python optimizer.scope.walk_in_scope: visits all nodes in the syntax tree, stopping at nodes that start child scopes.

    gen_week_offset_to_dow

    source
    fn gen_week_offset_to_dow(offset : Int) -> Int

    sqlglot.dialects.dialect.week_offset_to_dow.

    gen_week_start_day_to_dow

    source
    let gen_week_start_day_to_dow : Map[String, Int]

    sqlglot.dialects.dialect.WEEK_START_DAY_TO_DOW.

    generate_series_sql

    source
    fn generate_series_sql(func_name : String, exclusive_func_name? : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python generate_series_sql(func_name, exclusive_func_name).

    generatedasidentitycolumnconstraint_sql

    source
    fn generatedasidentitycolumnconstraint_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python generatedasidentitycolumnconstraint_sql (dialect helper): IDENTITY(start, increment).

    get_dialect

    source
    fn get_dialect(name : String) -> Dialect?

    Looks up a registered dialect by name (cached).

    getbit_sql

    source
    fn getbit_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python getbit_sql: GET_BIT, transpiled to (value >> position) & 1 when the zero index is the least-significant bit and the input is an integer.

    groupconcat_sql

    source
    fn groupconcat_sql(g : Generator, e : Expr, func_name? : String, sep? : String, within_group? : Bool, on_overflow? : Bool) -> String raise SqlglotError

    Python groupconcat_sql(self, expression, func_name="LISTAGG", sep=",",within_group=True, on_overflow=False). Pass sep="" for Python sep=None.

    highlight_sql

    source
    fn highlight_sql(sql : String, positions : Array[(Int, Int)], context_length? : Int) -> (String, String, String, String) raise SqlglotError

    Highlight a SQL string using ANSI codes at the given (inclusive) positions.

    ident

    source
    fn ident(name : String) -> Expr

    if_sql

    source
    fn if_sql(name? : String, false_value? : Expr) -> ((Generator, Expr) -> String raise SqlglotError)

    Python if_sql(name, false_value).

    if_sql_str

    source
    fn if_sql_str(name? : String, false_value : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python if_sql(name, false_value) with a string false_value (raw SQL).

    in_trie

    source
    fn in_trie(trie : Trie, key : ArrayView[String]) -> (TrieResult, Trie)

    Checks whether a key is in a trie.

    in_trie_chars

    source
    fn in_trie_chars(trie : Trie, key : ArrayView[Char]) -> (TrieResult, Trie)

    Checks whether a key (sequence of chars) is in a trie.

    inherit_struct_field_names

    source
    fn inherit_struct_field_names(expression : Expr) -> Expr raise SqlglotError

    Inherit field names from the first struct in an array.

    inline_array_sql

    source
    fn inline_array_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python inline_array_sql.

    inline_array_unless_query

    source
    fn inline_array_unless_query(g : Generator, e : Expr) -> String raise SqlglotError

    Python inline_array_unless_query.

    int64_range_error

    source
    fn int64_range_error(what : String) -> SqlglotError

    The error raised where Python would hold an integer outside the Int64 range: the port's AST integers (Value::Int), host ints (PyInt) and executor integers are 64-bit, so such values are refused instead of wrapping or being silently changed.

    int_str_from_base

    source
    fn int_str_from_base(text : String, base : Int) -> String raise SqlglotError

    Python str(int(text, base)): converts a (possibly huge) number written in base into its decimal representation.

    interval_day_time_match

    source
    fn interval_day_time_match(text : String) -> Bool

    INTERVAL_DAY_TIME_RE.match(text): \s*-?\s*\d+(?:\.\d+)?\s+(?:-?(?:\d+:)?\d+:\d+(?:\.\d+)?|-?(?:\d+:){1,2}|:)\s*

    interval_string_findall

    source
    fn interval_string_findall(text : String) -> Array[(String, String)]

    INTERVAL_STRING_RE.findall(text) returning (value, unit) pairs: \s*(-?[0-9]+(?:\.[0-9]+)?)\s*([a-zA-Z]+)\s*

    is_alnum

    source
    fn is_alnum(c : Char) -> Bool

    Python str.isalnum() for one character.

    is_alpha

    source
    fn is_alpha(c : Char) -> Bool

    Python str.isalpha() for one character.

    is_decimal

    source
    fn is_decimal(c : Char) -> Bool

    Python str.isdecimal() for one character (also re's \d).

    is_digit_char

    source
    fn is_digit_char(c : Char) -> Bool

    ASCII 0-9 (Python code testing membership in "0123456789").

    is_float_str

    source
    fn is_float_str(text : String) -> Bool

    Python float(text) succeeds.

    is_identifier_char

    source
    fn is_identifier_char(c : Char) -> Bool

    Python str.isidentifier() for a one-character string (XID_Start or _).

    is_identifier_continue

    source
    fn is_identifier_continue(c : Char) -> Bool

    Whether c may continue a Python identifier (XID_Continue).

    is_int_str

    source
    fn is_int_str(text : String) -> Bool

    Python int(text) succeeds.

    is_lower_char

    source
    fn is_lower_char(c : Char) -> Bool

    Python str.islower() for one character.

    is_numeric

    source
    fn is_numeric(c : Char) -> Bool

    Python str.isnumeric() for one character.

    is_parse_json

    source
    fn is_parse_json(e : Expr) -> Bool

    Python is_parse_json.

    is_printable

    source
    fn is_printable(c : Char) -> Bool

    Python str.isprintable() for one character.

    is_py_digit

    source
    fn is_py_digit(c : Char) -> Bool

    Python str.isdigit() for one character (includes e.g. superscripts like ²). See is_digit_char for the ASCII 0-9 test.

    is_safe_identifier

    source
    fn is_safe_identifier(text : String) -> Bool

    Whether text matches ^[_a-zA-Z][\w]*$ (Python SAFE_IDENTIFIER_RE; $ also matches before a trailing newline).

    is_space

    source
    fn is_space(c : Char) -> Bool

    Python str.isspace() for one character (also re's \s).

    is_upper_char

    source
    fn is_upper_char(c : Char) -> Bool

    Python str.isupper() for one character.

    is_word_char

    source
    fn is_word_char(c : Char) -> Bool

    re's \w for one character (str.isalnum() or _).

    isnull_to_is_null

    source
    fn isnull_to_is_null(args : Array[Expr]) -> Expr

    Python isnull_to_is_null(args).

    jarowinkler_similarity

    source
    fn jarowinkler_similarity(func : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python jarowinkler_similarity(func).

    json_extract_segments

    source
    fn json_extract_segments(name : String, quoted_index? : Bool, op? : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python json_extract_segments(name, quoted_index, op).

    json_path_key_only_name

    source
    fn json_path_key_only_name(g : Generator, e : Expr) -> String raise SqlglotError

    Python json_path_key_only_name.

    json_path_part_transforms

    source
    fn json_path_part_transforms() -> Map[Kind, (Generator, Expr) -> String raise SqlglotError]

    sqlglot.jsonpath.JSON_PATH_PART_TRANSFORMS.

    json_quote

    source
    fn json_quote(s : String) -> String

    Python json.dumps(s, ensure_ascii=False).

    kind_from_key

    source
    fn kind_from_key(key : String) -> Kind?

    Looks up a kind by its lowercase key, e.g. "select".

    kind_from_name

    source
    fn kind_from_name(name : String) -> Kind?

    Looks up a kind by its class name, e.g. "Select".

    left_to_substring_sql

    source
    fn left_to_substring_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python left_to_substring_sql.

    length_or_char_length_sql

    source
    fn length_or_char_length_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python length_or_char_length_sql.

    literal_int

    source
    fn literal_int(n : Int) -> Expr

    Builds a number literal from an integer.

    literal_number

    source
    fn literal_number(text : String) -> Expr

    Builds a number literal from its textual representation. Negative numbers are wrapped in Neg.

    literal_string

    source
    fn literal_string(s : String) -> Expr

    Builds a string literal.

    log_error

    source
    fn log_error(msg : String) -> Unit

    log_info

    source
    fn log_info(msg : String) -> Unit

    log_warning

    source
    fn log_warning(msg : String) -> Unit

    lstrip_chars

    source
    fn lstrip_chars(s : String, chars : String) -> String

    Python str.lstrip(chars).

    map_date_part

    source
    fn map_date_part(part : Expr?, dialect? : Dialect) -> Expr?

    Python map_date_part(part, dialect). dialect defaults to the base dialect.

    map_date_part_expr

    source
    fn map_date_part_expr(part : Expr, dialect? : Dialect) -> Expr

    Python map_date_part(part, dialect) for a non-optional part.

    max_int

    source
    fn max_int(a : Int, b : Int) -> Int

    max_or_greatest

    source
    fn max_or_greatest(g : Generator, e : Expr) -> String raise SqlglotError

    Python max_or_greatest.

    maybe_copy

    source
    fn maybe_copy(e : Expr, copy : Bool) -> Expr

    maybe_parse

    source
    fn[T : IntoPy] maybe_parse(sql_or_expression : T, into? : ArrayView[Kind], dialect? : Dialect, prefix? : String, copy? : Bool, error_level? : ErrorLevel) -> Expr raise SqlglotError

    Python maybe_parse: returns the given expression (copied if copy), or parses the given SQL code (str(sql_or_expression), optionally prefixed by prefix) into one of the kinds into.

    maybe_parse_str

    source
    fn maybe_parse_str(sql : String, dialect? : Dialect) -> Expr raise SqlglotError

    Python maybe_parse(sql, dialect=dialect) for a SQL string.

    merge_ranges

    source
    fn[T : Compare + Eq] merge_ranges(ranges : Array[(T, T)]) -> Array[(T, T)]

    Python helper.merge_ranges: merges a sequence of (low, high) ranges whose values belong to some totally-ordered set.

    merge_without_target_sql

    source
    fn merge_without_target_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python merge_without_target_sql: removes table refs from columns in WHEN clauses.

    min_int

    source
    fn min_int(a : Int, b : Int) -> Int

    min_or_least

    source
    fn min_or_least(g : Generator, e : Expr) -> String raise SqlglotError

    Python min_or_least.
    fn mk(kind : Kind, args : ArrayView[(String, &IntoValue)]) -> Expr

    Builds an expression, Python style: mk(Column, [("this", ident), ("table", tbl)]).

    mk0

    source
    fn mk0(kind : Kind) -> Expr

    Builds an expression with no arguments.

    mk1

    source
    fn mk1(kind : Kind, this : &IntoValue) -> Expr

    Builds an expression with a single this argument.

    mk2

    source
    fn mk2(kind : Kind, this : &IntoValue, expression : &IntoValue) -> Expr

    Builds an expression with this and expression arguments.

    months_between_sql

    source
    fn months_between_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python months_between_sql: transpiles MONTHS_BETWEEN to dialects without native support (DATEDIFF('month', d2, d1) + (DAY(d1) - DAY(d2)) / 31.0, with a last day of month check).

    move_ctes_to_top_level

    source
    fn move_ctes_to_top_level(expression : Expr) -> Expr

    Some dialects only allow CTEs to be defined at the top-level. This moves all nested CTEs to the top level (Python transforms.move_ctes_to_top_level).

    move_partitioned_by_to_schema_columns

    source
    fn move_partitioned_by_to_schema_columns(expression : Expr) -> Expr raise SqlglotError

    move_schema_columns_to_partitioned_by

    source
    fn move_schema_columns_to_partitioned_by(expression : Expr) -> Expr raise SqlglotError

    mul_

    source
    fn mul_(a : Expr, b : Expr) -> Expr

    Python expr * other.

    name_sequence

    source
    fn name_sequence(prefix : String) -> (() -> String)

    Returns a name generator given a prefix (e.g. a0, a1, a2...).

    new_trie

    source
    fn new_trie(keywords : Iter[String]) -> Trie

    Creates a new trie out of a collection of keywords.

    no_comment_column_constraint_sql

    source
    fn no_comment_column_constraint_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_comment_column_constraint_sql.

    no_datetime_sql

    source
    fn no_datetime_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_datetime_sql.

    no_ilike_sql

    source
    fn no_ilike_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_ilike_sql.

    no_last_day_sql

    source
    fn no_last_day_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_last_day_sql.

    no_make_interval_sql

    source
    fn no_make_interval_sql(g : Generator, e : Expr, sep? : String) -> String raise SqlglotError

    Python no_make_interval_sql(self, expression, sep=", ").

    no_map_from_entries_sql

    source
    fn no_map_from_entries_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_map_from_entries_sql.

    no_paren_current_date_sql

    source
    fn no_paren_current_date_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_paren_current_date_sql.

    no_pivot_sql

    source
    fn no_pivot_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_pivot_sql.

    no_recursive_cte_sql

    source
    fn no_recursive_cte_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_recursive_cte_sql.

    no_tablesample_sql

    source
    fn no_tablesample_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_tablesample_sql.

    no_time_sql

    source
    fn no_time_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_time_sql: transpiles BigQuery's TIME(timestamp, zone) to CAST(CAST(<timestamp> AS TIMESTAMPTZ) AT TIME ZONE <zone> AS TIME).

    no_timestamp_sql

    source
    fn no_timestamp_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_timestamp_sql.

    no_trycast_sql

    source
    fn no_trycast_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python no_trycast_sql.

    normalize_identifiers

    source
    fn normalize_identifiers(expression : Expr, dialect : Dialect, store_original_column_identifiers? : Bool) -> Expr

    normalize_identifiers(expression, dialect) (sqlglot.optimizer.normalize_identifiers).

    not_

    source
    fn not_(e : Expr, copy? : Bool) -> Expr

    exp.not_(expression) (copied unless copy is false).

    nth_value_from_sql

    source
    fn nth_value_from_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python nth_value_from_sql.

    null_

    source
    fn null_() -> Expr

    null_arg

    source
    let null_arg : Value?

    The "no value" argument, i.e. Python None.

    number_value

    source
    fn number_value(e : Expr) -> Value

    Python literal.to_py() for a numeric literal, as an argument value (int when integral, else the textual decimal).

    opt_list

    source
    fn opt_list(e : Expr?) -> Array[Expr]

    Python ensure_list(x) for an optional expression.

    or_

    source
    fn or_(conditions : Array[Expr], copy? : Bool, wrap? : Bool) -> Expr

    exp.or_(...) for expressions (copied unless copy is false).

    paren

    source
    fn paren(e : Expr, copy? : Bool) -> Expr

    exp.paren(expression) (copied unless copy is false).

    parse

    source
    fn parse(sql : String, dialect? : Dialect, error_level? : ErrorLevel, error_message_context? : Int, max_errors? : Int, max_nodes? : Int) -> Array[Expr?] raise SqlglotError

    Parses all statements of sql.

    parse_identifier

    source
    fn parse_identifier(name : String, dialect? : Dialect) -> Expr

    exp.parse_identifier(name, dialect)

    parse_int_checked

    source
    fn parse_int_checked(text : String) -> Int64? raise SqlglotError

    Python int(text) as an Int64: None when text isn't an integer literal, and int64_range_error when it is one outside the Int64 range.

    parse_int_str

    source
    fn parse_int_str(text : String) -> Int64?

    Parses a Python-style integer string (allowing _ separators and sign); None when it isn't an integer or is outside the Int64 range (see parse_int_checked).

    parse_json_path

    source
    fn parse_json_path(path : String, dialect : Dialect) -> Expr raise SqlglotError

    Takes in a JSON path string and parses it into a JSONPath expression.

    parse_one

    source
    fn parse_one(sql : String, dialect? : Dialect, into? : Array[Kind], error_level? : ErrorLevel, error_message_context? : Int, max_errors? : Int, max_nodes? : Int, into_is_list? : Bool) -> Expr raise SqlglotError

    Parses the given SQL string and returns a syntax tree.

    parse_one_with

    source
    fn parse_one_with(sql : String, read : String, into? : Array[Kind]) -> Expr raise SqlglotError

    Parses with a dialect given by name (e.g. "duckdb").

    pivot_column_names

    source
    fn pivot_column_names(aggregations : Array[Expr], dialect : Dialect) -> Array[String] raise SqlglotError

    Python pivot_column_names(aggregations, dialect).

    preprocess

    source
    fn preprocess(transforms : Array[(Expr) -> Expr raise SqlglotError], generator? : (Generator, Expr) -> String raise SqlglotError) -> ((Generator, Expr) -> String raise SqlglotError)

    Creates a generator function by chaining a sequence of transformations and converting the resulting expression to SQL (Python transforms.preprocess).

    properties_from_dict

    source
    fn properties_from_dict(properties : Map[String, PyObj]) -> Expr raise SqlglotError

    Properties.from_dict(properties)

    property_sql

    source
    fn property_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python property_sql (dialect helper): 'name'=value.

    property_to_name

    source
    let property_to_name : Map[Kind, String]

    exp.Properties.PROPERTY_TO_NAME.

    py_casefold

    source
    fn py_casefold(s : String) -> String

    Python str.casefold() (full Unicode case folding, e.g. ß -> ss).

    py_decimal_str

    source
    fn py_decimal_str(text : String) -> String

    Python str(Decimal(text)): keeps the literal mostly as written, normalizing exponent formatting and leading +/..

    py_float_repr

    source
    fn py_float_repr(d : Double) -> String

    Python repr(float).

    py_int_text_add

    source
    fn py_int_text_add(text : String, delta : Int) -> String?

    str(int(text) + delta) for an integer literal text of any size, else None.

    py_len

    source
    fn py_len(s : String) -> Int

    Number of code points of a string (Python len).

    py_list

    source
    fn[T : IntoPy] py_list(xs : Array[T]) -> Array[PyObj]

    Converts builder arguments to host values.

    py_lower

    source
    fn py_lower(s : String) -> String

    Python str.lower() (full Unicode case mapping, e.g. İ -> i̇, including the Final_Sigma rule for Σ).

    py_lstrip

    source
    fn py_lstrip(s : String) -> String

    Python str.lstrip().

    py_repr_str

    source
    fn py_repr_str(s : String) -> String

    Python's repr() for a string (single-quoted unless it contains single quotes only; non-printable characters are escaped as \xhh, \uhhhh or \Uhhhhhhhh).

    py_rstrip

    source
    fn py_rstrip(s : String) -> String

    Python str.rstrip().

    py_split

    source
    fn py_split(s : String, sep : String) -> Array[String]

    Python str.split(sep).

    py_split_ws

    source
    fn py_split_ws(s : String) -> Array[String]

    Python str.split() (no separator: splits on runs of whitespace).

    py_str_value

    source
    fn py_str_value(v : Value?) -> String raise SqlglotError

    Python str(value) for an argument value, as used in f-strings (str(expr) generates SQL with the default dialect).

    py_strip

    source
    fn py_strip(s : String) -> String

    Python str.strip() (whitespace).

    py_upper

    source
    fn py_upper(s : String) -> String

    Python str.upper() (full Unicode case mapping, e.g. ß -> SS).

    re_ignorecase_char_eq

    source
    fn re_ignorecase_char_eq(p : Char, c : Char) -> Bool

    Whether a pattern character p matches c under re.IGNORECASE (Unicode mode), as compiled by re: uncased characters match exactly; cased ones compare by _sre.unicode_tolower, also accepting re's extra equivalences (e.g. s/ſ, σ/ς).

    regexp_extract_sql

    source
    fn regexp_extract_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python regexp_extract_sql.

    regexp_replace_global_modifier

    source
    fn regexp_replace_global_modifier(e : Expr) -> Expr?

    Python regexp_replace_global_modifier.

    regexp_replace_sql

    source
    fn regexp_replace_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python regexp_replace_sql.

    register_dialect

    source
    fn register_dialect(name : String, make : () -> Dialect) -> Unit

    Registers a dialect constructor under name.

    remove_from_array_using_filter

    source
    fn remove_from_array_using_filter(g : Generator, e : Expr) -> String raise SqlglotError

    Python remove_from_array_using_filter.

    remove_precision_parameterized_types

    source
    fn remove_precision_parameterized_types(expression : Expr) -> Expr raise SqlglotError

    Removes the precision of parameterized types in expressions.

    remove_ts_or_ds_to_date

    source
    fn remove_ts_or_ds_to_date(to_sql? : (Generator, Expr) -> String raise SqlglotError, args? : Array[String]) -> ((Generator, Expr) -> String raise SqlglotError)

    Python remove_ts_or_ds_to_date(to_sql=None, args=("this",)).

    remove_unique_constraints

    source
    fn remove_unique_constraints(expression : Expr) -> Expr raise SqlglotError

    remove_within_group_for_percentiles

    source
    fn remove_within_group_for_percentiles(expression : Expr) -> Expr raise SqlglotError

    Transforms percentiles by getting rid of their corresponding WITHIN GROUP clause.

    rename_func

    source
    fn rename_func(name : String) -> ((Generator, Expr) -> String raise SqlglotError)

    Python rename_func(name): renders the expression as name(<all args>).

    replace_placeholders

    source
    fn replace_placeholders(expression : Expr, kwargs : Map[String, Expr]) -> Expr

    exp.replace_placeholders(expression, **kwargs)

    right_to_substring_sql

    source
    fn right_to_substring_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python right_to_substring_sql.

    select_

    source
    fn[T : IntoPy] select_(expressions : Array[T], dialect? : Dialect, copy? : Bool) -> Expr raise SqlglotError

    exp.select(*expressions)

    select_star_from

    source
    fn select_star_from(from_ : Expr?) -> Expr

    exp.select("*").from_(from_)

    sequence_sql

    source
    fn sequence_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python sequence_sql (for GenerateSeries / GenerateDateArray).

    set_operation

    source
    fn set_operation(kind : Kind, left : Expr, right : Expr, distinct? : Bool) -> Expr

    Builds a set operation (exp.union / exp.intersect / exp.except_).

    sha256_sql

    source
    fn sha256_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python sha256_sql.

    sha2_digest_sql

    source
    fn sha2_digest_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python sha2_digest_sql.

    simplify_hook

    source
    let simplify_hook : 
    Ref    [(Expr, Dialect) -> Expr raise SqlglotError?]

    sqlglot_anonymous

    source
    let sqlglot_anonymous : String

    sqlglot_meta

    source
    let sqlglot_meta : String

    starts_with

    source
    fn starts_with(s : String, prefix : String) -> Bool

    str_is_alnum

    source
    fn str_is_alnum(s : String) -> Bool

    Python str.isalnum()-like check used for plain words.

    str_is_digit

    source
    fn str_is_digit(s : String) -> Bool

    Python str.isdigit() for a whole string.

    str_is_identifier

    source
    fn str_is_identifier(s : String) -> Bool

    Python str.isidentifier().

    strip_chars

    source
    fn strip_chars(s : String, chars : String) -> String

    Python str.strip(chars).

    strposition_sql

    source
    fn strposition_sql(g : Generator, e : Expr, func_name? : String, supports_position? : Bool, supports_occurrence? : Bool, use_ansi_position? : Bool) -> String raise SqlglotError

    Python strposition_sql.

    struct_extract_sql

    source
    fn struct_extract_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python struct_extract_sql.

    struct_kv_to_alias

    source
    fn struct_kv_to_alias(expression : Expr) -> Expr raise SqlglotError

    Converts struct arguments to aliases, e.g. STRUCT(1 AS y).

    sub_

    source
    fn sub_(a : Expr, b : Expr) -> Expr

    Python expr - other.

    subclasses_of

    source
    fn subclasses_of(base : Kind) -> Array[Kind]

    Returns all concrete kinds that are subclasses of base.

    subsecond_precision

    source
    fn subsecond_precision(timestamp_literal : String) -> Int

    Port of sqlglot.time.subsecond_precision: given an ISO-8601 timestamp literal, e.g. '2023-01-01 12:13:14.123456+00:00', returns its subsecond precision (0, 3 or 6). Mirrors Python's datetime.fromisoformat; invalid literals yield 0.

    substr

    source
    fn substr(s : String, start : Int, end : Int) -> String

    Python str[start:end] on code points.

    suggest_closest_match_and_fail

    source
    fn[T] suggest_closest_match_and_fail(kind : String, word : String, possibilities : Array[String]) -> T raise SqlglotError

    Python suggest_closest_match_and_fail: raises a ValueError naming the closest candidate (similarity >= 0.6, approximating difflib.get_close_matches).

    table_of

    source
    fn table_of(name : String) -> Expr

    table name -> Table expression (Python maybe_parse(name, into=From) for a name).

    take_log_messages

    source
    fn take_log_messages() -> Array[String]

    Returns and clears the collected log messages.

    time_format

    source
    fn time_format(dialect? : String) -> ((Generator, Expr) -> String? raise SqlglotError)

    Python time_format(dialect): returns the time format of an expression unless it's equivalent to the default time format of dialect (the base dialect if omitted).

    timestampdiff_sql

    source
    fn timestampdiff_sql(g : Generator, e : Expr) -> String raise SqlglotError

    Python timestampdiff_sql.

    timestamptrunc_sql

    source
    fn timestamptrunc_sql(func? : String, zone? : Bool) -> ((Generator, Expr) -> String raise SqlglotError)

    Python timestamptrunc_sql(func="DATE_TRUNC", zone=False).

    timestrtotime_sql

    source
    fn timestrtotime_sql(g : Generator, e : Expr, include_precision? : Bool) -> String raise SqlglotError

    Python timestrtotime_sql(self, expression, include_precision=False).

    timezones

    source
    let timezones : 
    Set    [String]

    Lower-cased IANA time zone names (Python sqlglot.time.TIMEZONES).

    to_ascii_decimal

    source
    fn to_ascii_decimal(text : String) -> String

    Like CPython's _PyUnicode_TransformDecimalAndSpaceToASCII (used by int() and float()): replaces Unicode decimal digits by their ASCII digit and Unicode white space by a space.

    to_bool_str

    source
    fn to_bool_str(value : String) -> Bool?

    Python to_bool helper.

    to_identifier

    source
    fn to_identifier(name : String, quoted? : Bool) -> Expr

    Builds an identifier. When quoted is not given, the identifier is quoted only if it's not a safe identifier.

    to_identifier_expr

    source
    fn to_identifier_expr(e : Expr) -> Expr

    Copies an identifier expression (Python to_identifier(identifier)).

    to_identifier_value

    source
    fn to_identifier_value(name : Value, quoted? : Bool, copy? : Bool) -> Expr raise SqlglotError

    Python to_identifier(name, quoted, copy) for an identifier or a string value.

    to_number_with_nls_param

    source
    fn to_number_with_nls_param(g : Generator, e : Expr) -> String raise SqlglotError

    Python to_number_with_nls_param.

    to_table

    source
    fn to_table(name : String) -> Expr

    exp.to_table(name) for dotted names.

    token_repr

    source
    fn token_repr(t : Token) -> String

    Python repr(token).

    token_type_from_name

    source
    fn token_type_from_name(name : String) -> TokenType?

    transpile

    source
    fn transpile(sql : String, read? : Dialect, write? : Dialect, pretty? : Bool, identify? : String, error_level? : ErrorLevel, unsupported_level? : ErrorLevel) -> Array[String] raise SqlglotError

    Parses sql with read and generates it with write (Python sqlglot.transpile).

    trim_sql

    source
    fn trim_sql(g : Generator, e : Expr, default_trim_type? : String) -> String raise SqlglotError

    Python trim_sql(self, expression, default_trim_type="") (dialect helper).

    true_

    source
    fn true_() -> Expr

    ts_or_ds_add_cast

    source
    fn ts_or_ds_add_cast(e : Expr) -> Expr

    Python ts_or_ds_add_cast.

    ts_or_ds_add_return_type

    source
    fn ts_or_ds_add_return_type(e : Expr) -> Expr

    Python TsOrDsAdd.return_type: DataType.build(return_type or DATE).

    tsort

    source
    fn[T : Hash + Eq + Compare] tsort(dag : Map[T, Array[T]]) -> Array[T] raise SqlglotError

    Python helper.tsort: sorts a directed acyclic graph (node -> dependencies) in topological order; nodes that become ready at the same time are sorted. Raises ValueError("Cycle error") when the graph has a cycle.

    tsql_convert_format_mapping

    source
    let tsql_convert_format_mapping : Map[String, String]

    TSQL.CONVERT_FORMAT_MAPPING (used by the base convert_sql).

    tuple_

    source
    fn tuple_(expressions : Array[Expr], copy? : Bool) -> Expr

    exp.tuple_(*expressions) (copied unless copy is false).

    unabbreviate_unit

    source
    fn unabbreviate_unit(name : String) -> String?

    unabbreviated_unit_name

    source
    let unabbreviated_unit_name : Map[String, String]

    unicode_version

    source
    let unicode_version : String

    unit_to_str

    source
    fn unit_to_str(e : Expr, default? : String) -> Expr?

    Python unit_to_str(expression, default="DAY"). Pass default="" for Python None.

    unit_to_var

    source
    fn unit_to_var(e : Expr, default? : String) -> Expr?

    Python unit_to_var(expression, default="DAY"). Pass default="" for Python None.

    unnest_generate_date_array_using_recursive_cte

    source
    fn unnest_generate_date_array_using_recursive_cte(expression : Expr) -> Expr raise SqlglotError

    unnest_generate_series

    source
    fn unnest_generate_series(expression : Expr) -> Expr raise SqlglotError

    Unnests GENERATE_SERIES or SEQUENCE table references.

    unnest_to_explode

    source
    fn unnest_to_explode(unnest_using_arrays_zip? : Bool) -> ((Expr) -> Expr raise SqlglotError)

    Convert cross join unnest into lateral view explode.

    unqualify_columns

    source
    fn unqualify_columns(expression : Expr) -> Expr raise SqlglotError

    unqualify_pivot_fields

    source
    fn unqualify_pivot_fields(expression : Expr) -> Expr raise SqlglotError

    unqualify_unnest

    source
    fn unqualify_unnest(expression : Expr) -> Expr raise SqlglotError

    Remove references to unnest table aliases, added by the optimizer's qualify_columns step.

    var_

    source
    fn var_(name : String) -> Expr

    var_map_sql

    source
    fn var_map_sql(g : Generator, e : Expr, map_func_name? : String) -> String raise SqlglotError

    Python var_map_sql(self, expression, map_func_name="MAP").

    var_of_expr

    source
    fn var_of_expr(e : Expr) -> Expr

    exp.var(expr): builds a Var from an expression's name.

    walk_in_scope

    source
    fn walk_in_scope(expression : Expr, prune? : (Expr) -> Bool) -> Array[Expr]

    Visits all nodes in the syntax tree, stopping at nodes that start child scopes.

    week_offset_to_dow

    source
    fn week_offset_to_dow(offset : Int) -> Int

    Python week_offset_to_dow(offset): converts a dialect's WEEK_OFFSET (days relative to Monday) to the ISO day number of its week start.

    week_start_day_to_dow

    source
    let week_start_day_to_dow : Map[String, Int]

    Python WEEK_START_DAY_TO_DOW: days of week to ISO 8601 day-of-week numbers (Monday=1, ..., Sunday=7).

    week_unit_to_dow

    source
    fn week_unit_to_dow(unit : Expr?) -> Int?

    Python week_unit_to_dow(unit): the ISO 8601 week start day (Monday=1 .. Sunday=7) of a week-ish unit, e.g. BigQuery's WEEK() or ISOWEEK, or None if not a week unit or if the day is dynamic.

    weekstart_unit_to_str

    source
    fn weekstart_unit_to_str(g : Generator, e : Expr, default? : String) -> Expr? raise SqlglotError

    Python weekstart_unit_to_str(self, expression, default="DAY").

    wrap_binary

    source
    fn wrap_binary(e : Expr) -> Expr

    Wraps a binary operand in parentheses if needed (Python _wrap(e, Binary)).

    Source Files

    Powered by MoonBit

    Site sourceReport issuePackagesBuild queueSkillsStatistics

    © 2026 mooncakes.io