Flip between different query layer SQL definitions (for rapid spatial SQL development)

Bud — Wed, 12 Apr 2023 06:52:19 GMT

ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 EGDB

I have multiple query layers in the Contents pane of my map. I want to quickly navigate between the SQL definitions of the different query layers -- all within a single pane.

Reason: I want to do rapid spatial SQL development. Similar to what we can do in non-spatial SQL clients, except seamlessly visualize the spatial results in the map.

For example:

Make a change to the sidewalks query layer's SQL definition. Hit run.
In the same pane, quickly switch to the roads query layer SQL definition. Make a change and hit run.
Switch to a different query layer's SQL definition. Make a change. And so on.

Possible ideas:

Add a dropdown parameter to the Make Query Layer GP tool that lets me choose a different query layer and edit it. The rest of the parameters would get automatically populated from the existing query layer.
Or, create a new GP tool called Edit Query Layer. It would have a similar dropdown parameter to the one described above.
Or, create a new kind of pane called the Query Layer pane. Flip between different query layers and edit them.
Or, the new pane could be used for any kind of feature layer: query layers, feature layers, or standalone tables. The pane could either edit the definition query of regular layers, or edit the SQL definition of query layers (whatever applies). The pane could be called the SQL Query Pane, or the SQL Definition Pane, etc.
Or something better.

Would something like that be possible?

I'm aware of the Query Layer properties —> Edit Query Layer dialog. But I don't think that helps me since it can only be used to modify the one query layer.

Re: Flip between different query layer SQL definitions (for rapid spatial SQL development)

Bud — Wed, 29 Jan 2025 19:25:45 GMT

What does @TanuHoque think about this idea? Any plans for this kind of thing in the future?

Re: Flip between different query layer SQL definitions (for rapid spatial SQL development)

TanuHoque — Wed, 29 Jan 2025 22:20:40 GMT

@Bud

I see the idea is correctly labelled with Geodatabase. I think the team members will review this request and reply.

idea Flip between different query layer SQL definitions (for rapid spatial SQL development) in ArcGIS Pro Ideas

Flip between different query layer SQL definitions (for rapid spatial SQL development)

Re: Flip between different query layer SQL definitions (for rapid spatial SQL development)

Re: Flip between different query layer SQL definitions (for rapid spatial SQL development)