1) Query builder with filter input is very nice to guess from manfiold source the equivalent function to use in radian .But what is the equivalent of manifold function to radian for the 3 bold SQL functions :
CentroidX([Coord]) AS [x],
CentroidY([Coord]) AS [y]
--SPLIT BY Coords([ID]) AS [Coord]
2) in querybuilder about input and output in function , querybuilder use <> to name structure ( <json> , <value> , <table>, <json>,<gml>,<string>,<valuex2|3|4> ) and sometime no structure ( <manifold>,<epsg><subtype><converter>,<component>,<tile>,<image>). Is there some documentation in the case <name> is about not structure/type name ?
I think only the documentation has the answer to know the structure in each specific SQL function name .
--<component> mean all object type locate inside windows panel name ( <drawing> , <image> ,<table> ).
--<tile> is colum type inside <table>
But for others <name> it is difficult to know where those name appearin the Radian GUI !
To be bale to test SQL function name using begining "? CALL " without ending by ";" like in "? CALL CoordDatums()" is nice .
A contextual menu to go directly in the function name to documentation ll be nice !! (see virtual capture screen )
I never find an so easy SQL wizard (in meantime i not an SQL developper so don't test a lot of SQL tools) and lack of some projection knowledge ( at this time ) ..... when use Manifold /Radian ...