Re:Litdb – type safe SQL for JavaScript/TS
by lf-non on Friday December 06, 2024 @01:10AM
(#42336896)
Does using template strings not compromise with type-safety? The drizzle example will be a compile time error for example if id wasn't a numeric column.
Seems a strange design choice for a library that claims to offer a type-safe sql builder.
Re:Litdb – type safe SQL for JavaScript/TS
by mythz on Friday December 06, 2024 @01:38AM
(#42337026)
Right the SQL expression is validating that you're referencing tables that are included in the query and that all column references exist, not that the parameter value matches the property type, although SQLite and MySQL does allow you to use a string to query an int column, e.g:
SELECT * from Contact where id = '1'
With that said you can achieve something similar in litdb with a custom expression: const eq = <T,V>(ref:(x:T)=>V, value:V) => (x:T) => $`${ref(x)} = ${value}`
Which will type check that the value matches the column type: .where(eq(c => c.id, 2))
and fail type check when they don't: .where(eq(c => c.id, '2'))
Examples of other custom expressions: https://litdb.dev/#composable
Drizzle also uses its own custom query language e.g.
Whereas litdb lets you use the full expressiveness of SQL but ensures all references are typed: [1] https://orm.drizzle.team/docs/overview