Order by `rowid`?
Is it possible to order by (SQLite)
I need to order by
rowid?I need to order by
rowid as my table has no other natural sorting column.rowid?rowid as my table has no other natural sorting column.rowidrowid const driverFamilyRelationships = await c.var.f1db.driverFamilyRelationship.findMany({
where: {
AND: [{ driverId: driverId }, pageableQueryOptions.where],
},
orderBy: [
// TODO: { _raw: Prisma.sql`rowid` },
...pageableQueryOptions.orderBy,
],
skip: pageableQueryOptions.skip,
take: pageableQueryOptions.take,
});