Feature Request: Formatted, Multi-Line SQL Output

[vladjerca]

I was thinking about a small feature that could make it even better. Right now, when the logger prints a query, it's all on a single line. This works great for simple queries, but as soon as things get complex—with multiple JOINs, WHERE clauses, and subqueries—the output becomes a long, unreadable string.

It would be a huge quality-of-life improvement if the logger could format the SQL into a clean, multi-line structure.

Instead of the current output:

SELECT "posts"."id", "posts"."title", "users"."name" FROM "posts" LEFT JOIN "users" ON "posts"."author_id" = "users"."id" WHERE "posts"."status" = 'published'

We could see something like this:

SELECT
  "posts"."id",
  "posts"."title",
  "users"."name"
FROM "posts"
LEFT JOIN "users" ON "posts"."author_id" = "users"."id"
WHERE
  "posts"."status" = 'published';

This would make debugging complex queries so much faster since you wouldn't have to manually copy and paste the query into a formatter every time.

Is this something you'd consider adding? I think it would be a fantastic enhancement.

Thanks for the great work!

[vladjerca]

PS:

I was initially thinking I could hook https://github.com/sql-formatter-org/sql-formatter via the log config option but that prints each line individually so it's a no go 😅

[vladjerca]

@max-programming I have a quick hack here: https://github.com/vladjerca/drizzle-query-logger/tree/feat/formatter

LE: let me know if you like the direction z I'll open up a PR 😃

[max-programming]

Thanks @vladjerca

This does sound like a very good solution, although the size of sql-formatter is huge.
Instead, let's use @sqltools/formatter

Let me know when you open a PR

[vladjerca]

@max-programming there we go #4