Error in table views when handling geometry data "ST_Transform: Input geometry has unknown (0) SRID""

Description of the issue

Geometry data parsing error:

"ST_Transform: Input geometry has unknown (0) SRID"

Steps to Reproduce

Found on: https://openenergyplatform.org/database/tables/tutorial_example_table

Ideas of solution

I looked into the issue with claude and it digged up some interesting error prone geometry parsing happening on the database side. As the user can send a request that will parsed into SQL some specific use cases can lead to a malformed SRID value.

Another possible reason is that this happened after our last major infrastructure upgrade.

Context and Environment

• Version used:
• Operating system:
• Environment setup and (python) version:

Workflow checklist

• I am aware of the workflow in
  CONTRIBUTING.md

Start by reproducing the failure at the tutorial_example_table URL and trace how the table-view request parses geometry data into SQL. Check where the SRID becomes unknown (0), then verify the table view handles geometry with a valid SRID without raising ST_Transform errors.