sqlparse
sqlparse copied to clipboard
andialbrecht
A non-validating SQL parser module for Python
A query without MATERIALIZED is formatted e.g. like this ``` WITH test_data AS (SELECT data1, data2, data3 FROM test_table) SELECT * FROM test_data ``` after adding the MATERIALIZED keyword it...
I am concerned that this extraction of column names is a very common sql parsing application #680, but there is no relevant example in the example, and such an example...
Hi team, when using sqlparser to extract token names and their parameters from queries as indicated in the following image:  and given the following query:  when we try...
Hi team, I'm currently experiencing a formatter issue.  Do we have a temporary solution or are we going to fix this indentation...
Lexer.get_default_instance() is not working because the current release [0.4.3](https://github.com/andialbrecht/sqlparse/releases/tag/0.4.3) does not have the updated code for lexer in source code. Can you please fix it?
MSSQL has queries of the form `SELECT TOP 10 "name", "id" from some_table`, but `TOP` is misparsed as an identifer rather than a keyword. Would it be possible to add...
When there is a Window Function (e.g., `ROW_NUMBER()`) followed by `OVER ( ... )` in the expressions after the `SELECT` statement, these expressions are not split correctly into individual `Identifier`s....
Expressions containing string aggregation with group ordering are parsed incorrectly. Example: statement = parse("SELECT LISTAGG(attr,', ') WITHIN GROUP(ORDER BY attr) as column FROM table") print(statement[0].tokens) results in: [, , ,...
This PR adds 2 new dicts to extend sqlparse's lexer: 1 for Snowflake and 1 for BigQuery. The proposed dicts are not exhaustive, and only add keywords not already covered...
Right now, sqlparse treats `\` as an escape character in strings, but this is not universal across all sql dialects. postgres and athena/presto both do not consider `\` as string...
Metadata
Owner
Metadata
A non-validating SQL parser module for Python