sqlparse

sqlparse copied to clipboard

bug for example extract table name

4

it doesnt work for the example code to extract table name ``` SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName FROM ( (Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID) INNER JOIN Shippers ON...

shyandsy

extract(date from ...) formatter bug

1

When I try to use the formatter on the following SQL (valid in BigQuery) ``` select extract(date from cast(created_at as timestamp) at time zone 'America/New_York') as created_at from prod.orders ```...

pblankley

I noticed that `sqlformat` will concatenate statements together when using `-a` (`--reindent_aligned`) to format files. Below is a screenshot to show the issue. Basically, after formatting the file, `sqlformat` simply...

randomizedthinking

Error when copying a statement

1

The following minimal code yields an error. Code: ``` import sqlparse import copy query = 'SELECT * FROM adults WHERE age < 20' parsed = sqlparse.parse(query)[0] copied_parsed = copy.deepcopy(parsed) ```...

BStevanoski

Window Functions are Broken row_number() over (PARTITION BY foo ORDER BY bar)

2

>>> import sqlparse >>> sql = '''SELECT a, row_number() OVER (partition by foo ORDER BY bar), b, c, d, e, f FROM c''' >>> print(sqlparse.format(sql, reindent=True)) This outputs the following...

mkmoisen

Track positions of tokens

8

In some cases (error reporting, syntax highlighting), it might be desired to know the location of the tokens w.r.t. the original input.

sjoerdjob

Strip last statement when it only contains comment

1

It is also possible to add the last comment to the upper statement. However maybe this solution fits. What is also possible is to add an option to leave comments...

botenvouwer

Skip last statement when it only contains a comment

2

When you encounter a SQL file which ends with a comment the split function will see it as a valid statement: ``` DROP TABLE IF EXISTS schema_a.table_a CASCADE; DROP TABLE...

botenvouwer

Is there a reason why `IS NULL` keyword is not considered as comparison ? ``` >>> x = "something IS NULL" >>> parsed = sqlparse.parse(x)[0] >>> parsed.tokens [, , ,...

karimelghazouly

Keywords take precedence over Names

1

Ciao, I'm having a problem formatting a query with identifier_case = upper. It seems that the formatter cannot correctly recognize the name of an entity if its value is present...

bigluck