Comment by 1egg0myegg0

Hello! I would recommend trying out DuckDB's SQLite attach feature! You can read or write data, and even make schema changes, all with DuckDB's engine and syntax. The storage then uses SQLite, which is row oriented!

https://duckdb.org/docs/extensions/sqlite

(I work at MotherDuck and DuckDB Labs)