Firebird can be embedded, although neither the database itself, nor the embedded mode are as popular as they once were. It's a fully featured database though,

Firebird can be embedded, although neither the database itself, nor the embedded mode are as popular as they once were. It's a fully featured database though, with everything you expect from one, including actually working ALTER TABLEs.