A modern programming language that makes developers happier.

kotlinlang

ehm

```debt:
SELECT
    id, amount, otherAmount, suspended, otherAmountLevel, lastOverUsagePaymentTimestamp, otherAmountComputedTimestamp,
    details, payment_mutationState, payment_mutationId, payment_mutationTimestamp, subscriberId
FROM debt
WHERE subscriberId=?
LIMIT 1;```
how do YOU format long projections? keep it horizontally scrolling? column on new line? tabbed or not tabbed?

Depends on the situation, but I'll usually go with one per line

if so, do you then indent other parts as well?

```SELECT
    column,
    column,
    column,
    column,
    column,
FROM
    table```

Trailing commas are not allowed. I tend to do
```SELECT
    column
  , column
  , column
  , column
  , column
FROM
    table```
because the likelihood that you change the first column is near 0% (as it's usually the ID) whereas the likelihood you change the other columns is high relatively to the first.

it ensures the diff only ever affects a single line with addition/removal

neat .. okay so if it fits onto a line, then don't indent

```SELECT column1, column2
FROM table```
otherwise column per line + indent for everything, or do you find this still cool?

```SELECT
    column
  , column
  , column
  , column
  , column
FROM table
WHERE id=?```