Split clauses into two groups: multiline & single line

[nene]

So far pretty much all SQL clauses have been formatted like so:

CLAUSE_NAME
  more sql here

However, for many clauses this is not really how one would normally format SQL. For example, one rarely formats SQL like so:

TRUNCATE TABLE
  customers;

Rather one would format this on a single line:

TRUNCATE TABLE customers;

This change makes it so, that by default all clauses get formatted in the latter way. i.e. all clauses for which we don't have specific tests as to how we'd want them to be formatted. Most dialects have this sort of kitchen-sink list of clauses that's just been copied there from documentation. So these are all now being formatted in this one-line style. This will also aligns more with how the default sql-dialect formatter handles unknown SQL syntax.

Also hand-picked a few clauses for which I wanted to intentionally apply this style:

• TRUNCATE TABLE
• SET SCHEMA
• ALTER TABLE
• DROP TABLE
• DELETE FROM
• UPDATE

As a bonus, this also:

• Fixes [FORMATTING] [MySQL] Newline after USE keyword causes syntax error #456

[inferrinizzard]

can we not just use this as the default interface for DialectFormatOptions and add a wrapper function to transform the string[] into Record ?

[nene]

It's not only the onlineClauses field that differs. It's also the alwaysDenseOperators field which is originally optional, but then processed to be empty array if missing.

[inferrinizzard]

can be

Suggested change

	onelineClauses: Record<string, boolean>;
	onelineClauses: Record<string, true>;

[nene]

Tried that, but in this case TypeScript thinks that onlineClauses[anything] always evaluates to true.