How does PHQL translate to the respective RDBMS? How can I know what types of functions and syntax are supported by PHQL?
I just had some trouble trying to use INTERVAL, which is somewhat standard but is invalid syntax in Phalcon.
Although if I try using a function that doesn't exist or a field that doesn't exist, Phalcon doesn't trigger any error and even returns a result! How is that possible?
// doesn't trigger any error and returns data $result = MyModel::findFirst([ 'fieldthatdoesntexist' => '> FOOBARFUNCTION(1234)' ]);