What SQL commands do in_memory workspaces support?

Question

In_memory workspaces are great to work with, especially when needing temporary/intermediate steps in an ArcPy script. Currently I am using an arcpy.da.SearchCursor against one and using simple where_clause statements with operators (>, <, 😃 seem to work just fine. But trying to take it a bit further and use a sql_clause to prefix with a 'DISTINCT' or postfix with a 'ORDER BY' and it doesn't seem to obey those.

Is there any documentation that says what SQL is supported by these in_memory workspaces?

Thanks a lot for any help and information!

JoshuaBixby · Answer

Got it.  I do the same sometimes, but I was also wondering if you created an Idea or logged an enhancement request as well.  Although I agree the Feedback link does seem to get to the appropriate audience in Esri, I don't like the black box that it becomes.  Occasionally I start an e-mail dialogue with a Product Lead after submitting Feedback, but there is no formal structure for you to track status.

curtvprice · Answer

Hi Joshua.

Every ArcGIS help article has a link at the bottom: Feedback on this topic?

I have it on good authority these comments get forwarded directly to the person responsible for that help article at Esri. So I often take advantage of this to send a note directly to that page author when I find something that I find confusing or incomplete, (less commonly) wrong.

JoshuaBixby · Answer

I posted a request ....

An ArcGIS/GeoNet Idea or some other request?  If the latter, what and where?