db.max() return type is always number

[pocin]

Hey! I just noticed that doing

const q = db.max('table', db.all, {colums: ["end_date"])

compiles to a correct query

q.compile()
{
  text: 'SELECT max("end_date") AS result FROM "table"',
  values: []
}

but the return type is number which is not always the case (could be date or even string fwiw).

I would expect the return type to be inferred from the schema, but not sure if this is feasible.

In this particular case i can do

db.select('table', {order: {by: ['end_date'], direction: 'DESC'},limit: 1})

which is correctly typed, but wanted to report anyway

[jawj]

Thanks, this is a good point — I had originally envisaged this only as having numeric return values, but of course you are right that it's more widely applicable.