PowerSuite implements subset of the Microsoft SQL Server language as described in https://support.microsoft.com/en-us/office/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671
More:
Case statement
Operators
Column references.
Data Types
String functions
Treatment of NULL and empty string values.