Invantive UniversalSQL |
One of the most familiar questions at our support desk is "what functions are available" in Invantive UniversalSQL to query data in Exact Online.
This second-generation SQL parser is an extensive implementation of many commonly found SQL constructs from the ANSI SQL standard.
It includes in addition to the features of the first-generation SQL parser also:
•joins,
•outer joins,
•cross joins,
•group functions such as stddev, avg and listagg,
•value functions such as xmlescape and round.
There are two flavors shipped:
•Free version: second-generation SQL parser without joins and some upcoming non-ANSI standard advanced mapping functions for large volume financial analysis and reporting.
•Paid version: identical to the free version but with joins and advanced mapping functions.
The EBNF-grammar in Grammar depicts the possibilities.