Add exception test on scanning vs parsing #2977

Job	Run time
setup / Get and cache Dart dependencies	30s
setup / Compile sqlite3 for tests (ubuntu-latest)	7s
setup / Compile sqlite3 for tests (macos-latest)	9s
setup / Compile sqlite3 for tests (windows-latest)	14s
drift_dev	6m 35s
Documentation	4m 57s
drift package	2m 15s
Integration tests	2m 55s
sqlparser	37s
Integration tests for migration tooling	1m 8s
test_flutter (3.24)	2m 6s
drift_web_ddc	3m 32s
Web integration tests	3m 46s
Drift web unit tests, dart2wasm, chrome	3m 31s
Drift web unit tests, dart2wasm, firefox	3m 52s
	36m 14s

Provide feedback