Generic SQL formatters don't know PostgreSQL, and it shows Tags: postgres, sql, tooling, webdev

Paste a Postgres query into a random online SQL formatter and most of the time it looks fine. Then you hit the one with a cast, a JSON operator or a function body, and the layout goes strange. There is rarely an error. You just get id::text split across two lines, or meta ->> 'plan' laid out like three unrelated tokens. The reason is that a... Weiterlesen: Generic SQL formatters don't know PostgreSQL, and it shows Tags: post…