06/25/2022, 10:51 AM
Is the a way for SQLDelight to allow unrecognized expression? I use SQLDelight's mysql dialect on my server. Recently I plan to migrate a table to combine many fields into a JSON field so the server code no longer needs to know the complex data structure. As part of the migration, I need to do something like this during runtime - when the sever sees a client with the new version, it knows the client won't access the old table anymore, so it's safe to migrate the record to new table. INSERT OR IGNORE INTO new_table SELECT id, a, b, JSON_OBJECT('c', c,...