Integration tests

infer `PREFECT_PROFILES_PATH` from `PREFECT_HOME` #20535

# to view logs

Run time

Learn about OS # on GitHub Actions

Job	Run time
Integration tests @main	4m 59s
Test SQLite 3.24.0 Compatibility	2m 40s
Test SQLite 3.31.1 Compatibility	2m 40s
	10m 19s