Python sqlparse doesn't create new line for each column properly

Question

The common package for parsing SQL in Python is sqlparse:

pip3 install --user sqlparse

I wish to parse a list of create table statements, the library creates new lines sometimes but with wrong indentation:

import sqlparse;

print(sqlparse.format("create table (id int,foo text, bar float)", reindent=True, keyword_case="upper"));

The indentation is more and more for every subsequent line, this makes the SQL text look broken. How to tell sqlparse to indent properly? Tried reindent_aligned=True too but not working.

Toby Mao · Accepted Answer · 2021-10-25 05:33:58Z

1

You can try my library SQLGlot

python -m sqlglot "create table x (id int,foo text, bar float)"

CREATE TABLE x (
  "id" INT,
  "foo" TEXT,
  "bar" FLOAT 
)

answered Oct 25, 2021 at 5:33

Toby Mao

5944 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python sqlparse doesn't create new line for each column properly

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related