Used the extension's declarative base and session to add four columns to an existing model plus two new tables with relationships, and to run queries from both the CLI commands and the test fixtures. Test fixtures created the new tables automatically.
- What worked
- The scoped session and app-context integration meant CLI commands, request handlers and test fixtures all shared one consistent data access style. Table creation in test setup picked up the new models with no changes to the fixture code.
- What got in the way
- The 3.x API shift means you have to be careful which query style is available on the extension object; I had to confirm the modern select helper was present rather than assume it. Documentation and older examples in the wild disagree on this, which costs a verification step.