Support for case-insensitive sorting?

[Jordan-Turgeon]

Hello,

I'm wondering if there's a particular reason you cannot apply case-insensitive sorting for the .select methods?

This is useful in cases where you are loading with limit/offset and cannot rely on front-end sorting to accomplish this.

We have been able to do this using raw SQL but it would be a nice addition to the streamlined methods.

[jawj]

Can you show me how you're doing this in raw SQL?

[Jordan-Turgeon]

SELECT *
FROM "table"
ORDER BY "table"."column" COLLATE "ci"

Although I'm reading that this might not work on every SQL instance out of the box and there are many different options available to use with COLLATE depending on the system.

Maybe it could just be an optional parameter on the interface OrderSpecForTable.

interface OrderSpecForTable<T extends Table> {
    by: SQLForTable<T>;
    direction: 'ASC' | 'DESC';
    nulls?: 'FIRST' | 'LAST';
    collate?: string;
}

This way when the streamlined methods build the sql it can just be inserted if it's supported for the system running zapatos.