QGIS expresion bulider base on SQL mixed with Python. Some elements of SQL works, some elements of python also works, but not all. For example single qoute is for string, double qoute is for reference to field in atribute table.

For more information look for official documention for QGIS docs.qgis