Using geography cast as geometry in QGIS No SRID in Airports table. Other table have geom and is 26986

I trying to add a layer into the map in QGIS. It will execute the SQL and show the answer but will not add it to the map. It states there a geometry error. I type cast geom::geography it should allow it.

SELECT name, iso_country, iso_region, ST_Transform(geog::geometry,4326)
FROM ch10.airports
WHERE ST_DWithin(geog, ST_Point(-94.173653,36.067833)::geography, 100000)
LIMIT 5;