SQL Compatibility

When writing expressions in WEM to filter data or loop through lists to make changes, some parts of these expressions may be SQL Compatible - which means that these parts of the expression can be transformed to native SQL statements or they can be handled as static values, and the database server can work with it directly. This is the optimal situation. When expressions are NOT SQL Compatible, this means that more rows and data need to be retrieved from the database and the expression needs to be executed in memory. It can even need more than one database queries to be handled. So, when accessing data in the database using filters or loops, it will be useful to know a bit about the SQL Compatibility of your expressions.

In this section we provide the SQL Compatibility information on Functions, Keyword and Operators in the WEM Expression language.

FunctionsKeywordsOperators