I need to download and access multiple https://www.geopackage.org which use SQLite as a data format in a multiplatform library. This format has a table with rows of table names and the data will be in those other tables. Is it possible to create query in SQLDelight that can use dynamic table names*?*
d
Derek Ellis
10/27/2023, 4:17 PM
Unfortunately no, not for code generation. Since GeoPackages have a fixed schema for its tables, I think you could write a wrapper around SQLDelight's
SqlDriver
and implement the queries yourself with manually-defined types though. That way you'd still get to use the multiplatform
SqlDriver
implementations.
➕ 1
m
mkrussel
10/27/2023, 5:13 PM
I think that is probably the route I would go with