Inspection

Inspection is about making generated schema and SQL behavior visible while you iterate.

For Flutter and Dart, keep generated output in a stable folder such as lib/db/generated so your IDE can inspect generated params, result rows, and adapters as you edit SQL:

flutter pub run sqlitenow_cli generate
dart analyze
flutter test

When you need to inspect the schema state that the compiler inferred, persist the inspected schema database from sqlitenow.yaml:

databases:
  AppDatabase:
    input: lib/db/sql/AppDatabase
    output: lib/db/generated
    package: app.db
    runtime: dart
    schemaDatabaseFile: build/sqlitenow/schema.db

The file is recreated when generation runs, and you can open it with a SQLite client to inspect tables, indexes, views, and inferred schema state.