I have a data table in Oracle I am trying to query and show as a point feature layer using an edit query layer. I can do this in QGIS fairly easily with

SELECT *, make_point(LONGITUDE, LATITUDE, 4269) as geometry
FROM MyTable
WHERE ID = 27

Carrying this directly over to ArcPro didn’t work but I managed to get validation with

SELECT * FROM MyTable;
make_point(LONGITUDE, LATITUDE, 4269) as SHAPE
WHERE ID = 27

In ArcPro the dialog box has two options before continuing; A) Let ArcGIS Pro discover spatial properties for the layer
and B) Define spatial properties for the layer as Radio button options but neither works in the next step for me to define what the geometry is or the column.

I’m not finding much help on in the Esri documentation either; all the examples assume the table is spatial in nature.
What steps am I missing?