But you have to pre-specify the columns. In a truly dynamic DB, you could enter "INSERT INTO foo (myNewColumn) VALUES (123)" and both the table "foo" and "myNew

But you have to pre-specify the columns. In a truly dynamic DB, you could enter "INSERT INTO foo (myNewColumn) VALUES (123)" and both the table "foo" and "myNewColumn" are created on the fly. SqlLite doesn't do this. Further, one could add restrictions as needed to "lock down" both new column creation, and add type-like validation ("parse" check). Thus, as requirements solidify, it can act more like a traditional RDBMS.