Create Database View — SQL Expression Builder

[Bud]

It would be helpful if we could use the SQL Expression Builder in the Create Database View geoprocessing tool.

Source: @AlfredBaldenweck 's comment in Improve SQL Expression Builder

The weird thing is that the implementation of various [SQL Expression] features we want is all over the place. We have them in some workflows but not others.

...Creating a view? Good luck.  You gotta know your datasets very well before you can successfully write the query.

Related: Consistent .exp SQL expression loading/parsing in GP tools

[AlfredBaldenweck]

Hard agree, whoever originally said that is a genius (hahahaha).

Having some sort of expression builder, as well as a validator, would be awesome.

The current method of "write your query and then see if fails halfway through" is... suboptimal.

[KariBuckvold]

agree! building a definition query will give you clues as to errors in your script but absolutely none for this tool.