Chore: Fix tests and adapt parser methods for tokens size #3504

Job	Run time
test-dbt-versions (1.6)	1m 42s
test-dbt-versions (1.5)	2m 3s
test-dbt-versions (1.9)	1m 30s
changes	5s
test-dbt-versions (1.10)	1m 40s
test-dbt-versions (1.4)	1m 35s
test-dbt-versions (1.3)	1m 28s
test-dbt-versions (1.8)	1m 46s
test-vscode	1m 0s
test-dbt-versions (1.7)	1m 45s
test-vscode-e2e	0s
doc-tests	34s
style-and-cicd-tests (3.11)	5m 14s
migration-test	1m 28s
style-and-cicd-tests (3.10)	5m 16s
style-and-cicd-tests (3.13)	3m 38s
cicd-tests-windows	4m 41s
style-and-cicd-tests (3.9)	5m 16s
style-and-cicd-tests (3.12)	5m 16s
engine-tests-docker (mysql)	1m 42s
engine-tests-docker (risingwave)	2m 50s
engine-tests-docker (spark)	4m 23s
engine-tests-docker (clickhouse)	2m 59s
engine-tests-docker (trino)	3m 52s
engine-tests-docker (duckdb)	2m 6s
engine-tests-docker (mssql)	1m 41s
engine-tests-docker (postgres)	2m 21s
ui-test	0s
ui-style	0s
engine-tests-cloud	1s
	1h 7m 52s

Provide feedback