This could work for a simple key-value store; but SQLite also does referential integrity which means we might just end up with extra entries with no entities on

This could work for a simple key-value store; but SQLite also does referential integrity which means we might just end up with extra entries with no entities on the other side of the table. IMO, best avoided in a transactional database.