search

andialbrecht / sqlparse

A non-validating SQL parser module for Python
BSD 3-Clause "New" or "Revised" License
3.72k stars 694 forks source link

Bad intent for formatting PostgresSQL EXTRACT statement #348

Open zh-h opened 7 years ago

zh-h commented 7 years ago

Unfriendly intent formated

ORDER BY EXTRACT('year'
                 FROM "cmdb_asset"."delete_date") ASC, EXTRACT('month'
                                                               FROM "cmdb_asset"."delete_date") ASC, EXTRACT('day'
                                                                                                             FROM "cmdb_asset"."delete_date") ASC;
xnmp commented 7 years ago

Can confirm that this is inconvenient. I actually came here to post the same thing.