There have been multiple instances of folks wanting a dataframe but do not necessarily have a geom column to use the query_to_geopandas function which requires a resulting column to be name by sql geom to work.
This can be solve with two approaches.
Add a kwarg pass through for the geom column name for columns that geometry but are not named geom
Add in a new function called query_to_pandas to get out a datafram when no geometry is available.
There have been multiple instances of folks wanting a dataframe but do not necessarily have a geom column to use the
query_to_geopandas
function which requires a resulting column to be name by sqlgeom
to work.This can be solve with two approaches.