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](https://cloud.invantive.com/sql-grammar/invantive-sql-grammar-current.html) depicts the possibilities.