Oracle:
It would be really helpful if we could get a function in ST_Geometry that would let us select the vertices of a feature as rows.
Oracle’s SDO_Geometry has a function called GetVertices. It is extremely handy.
https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF...
We need to be able to easily access ST_Geometry feature vertices using SQL -- without using clunky workarounds like cross joins or custom types/functions.