sqlparse
sqlparse copied to clipboard
Different behaviour library and sqlformat.org
I am trying to parse an SQL query:
do $$
declare
content_count int = 10;
begin
/*comment*/
select 1;
end; $$
sqlformat.org parse and highlight it correctly:
But when I try to do it in Python:
import sqlparse
def parse(s: str):
res = sqlparse.parse(s)
print(res[0].tokens)
parse("""
do $$
declare
content_count int = 10;
begin
/*comment*/
select 1;
end; $$""")
I get :
[<Newline ' ' at 0x7AB1C28A8408>, <Keyword 'do' at 0x7AB1C28A8468>, <Whitespace ' ' at 0x7AB1C28A84C8>, <Literal '$$ dec...' at 0x7AB1C28A8528>]
What am I doing wrong?