Fix query for subflow cancellation #16758

Job	Run time
pydantic v1, python:3.8	7m 48s
pydantic v2 internals, python:3.8	8m 6s
pydantic v1, python:3.12	7m 45s
pydantic v2 internals, python:3.12	8m 43s
sqlalchemy v1, postgres:14 python:3.8	7m 46s
python:3.8, postgres:14	8m 41s
sqlalchemy v1, postgres:14 python:3.12	7m 47s
python:3.9, postgres:14	7m 51s
sqlalchemy v1, sqlite python:3.8	10m 49s
docker, python:3.8	5m 39s
python:3.10, postgres:14	7m 45s
DataDog CI Visibility	0s
sqlalchemy v1, sqlite python:3.12	11m 13s
docker, python:3.9	5m 36s
python:3.11, postgres:14	7m 5s
python:3.12, postgres:14	7m 41s
docker, python:3.10	5m 33s
python:3.8, sqlite	11m 30s
python:3.9, sqlite	10m 44s
docker, python:3.11	5m 39s
python:3.10, sqlite	10m 28s
docker, python:3.12	5m 50s
python:3.11, sqlite	9m 49s
python:3.12, sqlite	11m 50s
notify-tests-failing-on-main	0s
	3h 11m 38s

Provide feedback