1 of 1 people found this helpful
These two blog posts (one is mine) cover everything available.
This is kind of one of those hidden things that have been around, people have used (plugins opened the functionality before ExecuteSQL offered it natively).
They really aren't a calculation function or a script step, so it really falls outside of the traditional area for documentation. It's more of a method that was put together by different developers over the years.
Since it's not a "promised" feature of FM, it could potentially be removed at anytime, but it's pretty harmless so it's just left open AFAIK.
I've already feature requested an expansion of this ability. There is tons more schema data there (IE layouts, scripts, layout objects, relationships) that would be very useful.