sqlite supports storing json https://www.sqlite.org/json1.html

Thanks for the answer. Sorry for the newbie question, but how can I use it in Clojure?

just create text fields in your database and then convert to json before writing to the db and parse json after reading from the db.

The main task that I have is actually taking a JSON file with multiple objects that have different (partially common) scheme and add all the file to a table in my SQLite database.

you could put the common fields into columns and write the rest into a text field as json, then?

and then use the functions I linked when you need to query on json

Thanks