@brianwilson
Do you see any errors in the Metabase log?
I don’t know what the “perfect” solution would be, but a work-around might be to create Views, where you convert the columns into formats that Metabase plays nice with.
SQLite isn’t a database I work with normally, so I lack knowledge about it’s quirks.