How to do case-insensitive sort?

[sebpowell]

How can I create the following query using the query builder?

select * from shops ORDER BY lower(shops.name)

I assume it would end up looking something like this:

await db.query.shops.findMany({
  orderBy: asc(lower(shops.name)),
});

But no such method ('lower') exists, and I can't spot anything in the docs. Do I need to keep this as a raw query, or is there a way round? Thank you in advance for any pointers.

[theotherdefranco]

Commenting for reach. Running into a similar situation

[Jim-salies]

asc and desc functions types show that sql function is accepted so this should do the job :

await db.query.shops.findMany({
  orderBy: asc(sql`lower(${shops.name})`)
});

[theotherdefranco]

That did it for me, thanks!

[sebpowell]

Perfect, thank you @Jim-salies!