ServiceStack v10.4 lets typed OrmLite queries reach into complex properties such as x.Address.City or x.Lines.Any(...). The expressions are translated to the native JSON functions of SQLite, PostgreSQL, SQL Server and MySQL, so one query works across all four. This removes the need for Sql.Json() wrappers on complex properties.
Schemity, a desktop ERD tool, read two real SQLite schemas, Campfire on Rails 8 and Jellyfin on EF Core 10, and rebuilt database files from the SQL it wrote. Before the fixes, declared column types, partial and expression indexes and AUTOINCREMENT settings were lost. The post is a useful case study for anyone who edits or migrates SQLite schemas with a tool.
Jeremy D. Miller shows how Marten stores a class hierarchy in one PostgreSQL table and queries it with LINQ, without the table-per-type or table-per-concrete-type decisions EF Core requires. He also covers subtype-specific partial indexes and duplicated fields. For teams weighing document storage against EF Core inheritance mapping, it is a useful comparison.