Module zut.sql

Parse and transform SQL queries.

Functions

escape_identifier(value, *[, force, quotechar])

escape_literal(value)

Simple SQL literal escape.

exclude_select_columns(sql, excluded_columns)

Rewrite a SQL SELECT query by excluding some column expressions.

get_create_statement_names(sql, *[, ...])

Get a list of object creations detected in the given SQL statement.

get_sqlutils_path(scheme)

parse_identifier(value, *[, quotechar])

parse_select_column_comments(sql)

parse_select_column_specs(sql)

parse_select_column_tags(sql)

Classes

Column(name[, type, precision, scale, ...])

Column name with details, used in databases and CSV files.

ForeignKey(related_table, columns, *[, basename])

Identifier(schema, name)

UniqueKey(columns, *[, nulls])