sqlparse icon indicating copy to clipboard operation
sqlparse copied to clipboard

A non-validating SQL parser module for Python

Results 194 sqlparse issues
Sort by recently updated
recently updated
newest added

reindenting queries with lists can take a very long time ``` python In [11]: %timeit sqlparse.format('SELECT foo FROM foo WHERE foo IN (' + ','.join(['1'] * 3) + ')', reindent=True)...

It seems that `sqlparse.format` considers words like `date` and `segment` as SQL identifiers, and so when these words are used as identifiers with `keyword_case=True`, `sqlparse` will automatically uppercase them. It...

I've been working with the extract_table_names.py example for about a day now to try and parse the following queries. I have been able to get sqlparse to return all the...

Try this input (it is valid in TSQL) ```sql /* outer comment start bla bla bla /* inner comment */ select a from b outer comment end */ create view...

## Problem Common keywords in SQL query like `uuid`, `private`, `version` are identified as keywords and affected tokenization result. ## Proposal If user can choose the type of SQL engine...

For Case expression is not designated as element of Comparison statement, so assignment in Update statement is parsed incorrect when its right hand value is Case expression. expected: ```sql UPDAT...

` Select A,B from table1 order by ASC ` For this query (though the query is incorrect), tokens are as follows: ` [, , , , , , , ,...

I have issues with block comment over several lines. I use strip_comments=true to remove them and unify the sql a little bit to be able to parse, but comment create...

Hi, I was thinking that it would be nice to set up continuous fuzzing of sqlparse, by way of OSS-Fuzz. In this PR: https://github.com/google/oss-fuzz/pull/4994 I have done exactly that, namely...