sqlparse

sqlparse copied to clipboard

Extent of customizability

1

Hi there! I just found this library and I'm stoked because there are very very few good formatting options for SQL--at least that can be used on the command line....

tcunnington

I find that `StripWhitespaceFilter` may modify Whitespace token's `value` attribute directly, but `normalized` attribute is not updated. `Token`'s method `match()` relies on `normalized` attribute, and may not work as intended.

shaowen310

I wanna parse an Oracle sql using `sqlparse.parse` and see the content of parse tree. SQL Syntax: ```sql select FULL_LINK.t_E_join.id_e id_, FULL_LINK.t_B_join.*, FULL_LINK.t_E_join.name_e from FULL_LINK.t_B_join, FULL_LINK.t_E_join where FULL_LINK.t_E_join.id_e = '1'...

MIllionBenjamin

Adding support for options when parsing

4

Addresses #384. Options added: - sql_dialect This option allows the user to select which sql dialect to use when parsing. Prior to this support, all SQL dialects (PGSQL, MYSQL, TSQL,...

MrMeemus

This tool does not support Chinese?

4

When I try to format an SQL statement containing Chinese, it gives the following error. ```sql select * from mytest where name='测试'; ``` ``` Error: Traceback (most recent call last):...

craneyuan

Format of postgresql json in select

1

For some reason when accessing json/jsonb structures in a select statement these statements get indented incorrectly: ``` select id, created_at, updated_at, row->'name', row->'age', row->'email' from users; ``` The command I...

tobstarr

# Thanks for contributing! Before submitting your pull request please have a look at the following checklist: - [x] ran the tests (`pytest`) - [ ] all style issues addressed...

proddata

**Describe the bug** Dollar quoted strings (e.g. PostgreSQL) are not properly detected, when there is an operator directly preceding the dollar quoted string (e.g `var=$$text$$`). While according to PostgreSQL docs...

proddata

Incorrect splitting of postgres function containing dollar-quoted semicolon

1

In the python console: ``` >>> sqlparse.split('''CREATE OR REPLACE FUNCTION public.bug() RETURNS text ... LANGUAGE sql ... AS $func$ ... select $string$ Run this query: SELECT 123; $string$::text; ... $func$;''')...

koljonen

**Describe the bug** When I'm using an "INSERT" preceded by "USE dbname; GO;", typically used in SQL Server, the first INSERT gives an error, being recognized as UNKNOWN . Example...

michelmetran