Support for JSON custom type in SQLite

[hellais]

I see that work has been done to add support for the JSON type in the MySQL driver (https://github.com/upper/db/pull/406) and it would be awesome if SQLite were to have similar support.

Given that currently there doesn't seem to be support for it in SQLite, what would be the best way to deal with JSON SQLite columns when defining the models?

Is the best practice to use string and then "manually" cast it to JSON with the golang Marshal Unmarshal function or is it something else?

How would this work when doing aggregate queries on JSON fields?