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.