Is it possible to configure nuxeo 5.5 to write queries in simple SQL instead to NXQL?
In Nuxeo the main way to do searches is through NXQL, the Nuxeo Query Language, a SQL-like query language.
Is it possible to use plain SQL lanaguage instead of NXQL,so that i dont need to do Complex property references(i.e dc:title,dc:subjects etc) after the SELECT, in the WHERE clause, and in the ORDER BY clause.
Please let me know if this possible
It's not possible. But I don't understand what it would gain you anyway, what's wrong with the current NXQL? It gets translated into pretty optimal SQL internally. Also note that
dc:title is not a “complex property”.