> q = SELECT.from(Authors).columns('name', 'dateOfDeath') .orderBy`dateOfDeath asc nulls first`
cds.ql {
  SELECT: {
    from: { ref: [ 'sap.capire.bookshop.Authors' ] },
    columns: [ { ref: [ 'name' ] }, { ref: [ 'dateOfDeath' ] } ],
    orderBy: [ { ref: [ 'dateOfDeath' ], sort: 'asc', nulls: 'first' } ]
  }
}
> q.forSQL()
cds.ql {
  SELECT: {
    from: { ref: [ 'sap.capire.bookshop.Authors' ], as: 'Authors' },
    columns: [
      { ref: [ 'Authors', 'name' ] },
      { ref: [ 'Authors', 'dateOfDeath' ] }
    ],
    orderBy: [ { ref: [ 'dateOfDeath' ], sort: 'asc', nulls: 'first' } ]
  }
}
> q.toSQL()
{
  sql: `
SELECT
    json_insert(
        '{}',
        '$."name"',
        name,
        '$."dateOfDeath"',
        dateOfDeath
    ) as _json_
FROM
    (
        SELECT
            Authors.name,
            Authors.dateOfDeath as dateOfDeath
        FROM
            sap_capire_bookshop_Authors as Authors
        ORDER BY
            dateOfDeath ASC
    )
`,
  values: []
}