[x] I have verified my changes didn't break the example project.
Description
This dialect used the built-in Kysely SqliteIntrospector class as its introspector, which under the hood makes queries to the sqlite_master table, which in D1 is a no go - I've extended SqliteIntrospector into a D1Introspector to support using the table_list and table_infoPRAGMAs to query table metadata instead.
Also, I've bumped up the version of kysely to the latest while I'm here as there were type discrepancies between 0.23.3 and 0.26.3.
example
project.Description
This dialect used the built-in Kysely
SqliteIntrospector
class as its introspector, which under the hood makes queries to thesqlite_master
table, which in D1 is a no go - I've extendedSqliteIntrospector
into aD1Introspector
to support using thetable_list
andtable_info
PRAGMA
s to query table metadata instead.Also, I've bumped up the version of
kysely
to the latest while I'm here as there were type discrepancies between0.23.3
and0.26.3
.