DBD::SQLite supports custom collations. This is a useful feature for e.g. sorting version numbers. It would be nice if DBDish::SQLite also supported this.

Relevant API: https://www.sqlite.org/c3ref/create_collation.html

Example usage:

$dbh.create-collation(‘version’, { Version.new($^a) cmp Version.new($^b) });

$dbh.execute(q:to/SQL);
    SELECT * FROM tbl ORDER BY vsn COLLATE version
    SQL