qgis - How to get the geometry value from all spatial tables in postgresql database

I'm trying to query the_geom value for all spatial tables in our DB.

For one, I know I can get the tables in question with:

select * from geometry_columns where f_table_name like 'ParcelPoints%';

But is it possible to get all the geometry values from all tables at once?

Ultimately, I'd like to perform something like the following where '...public."ParcelPoints_01001"...' is the result of all geometry values of all tables:

select the_geom from public."ParcelPoints_01001" WHERE ST_DWithin(the_geom, ST_MakePoint(-86.852470,32.628280)::geography, 1000) limit 3000;