Hello,
To build queries, QxOrm library provides the
qx::QxSqlQuery class (or its
qx_query alias) :
http://www.qxorm.com/doxygen/html/class ... query.htmlThere is a FAQ here :
http://www.qxorm.com/qxorm_en/faq.html#faq_210If you want to use a special feature provided by your SGBD (like JSON for example), you can use the
freeText() method of
qx::QxSqlQuery class.
Or you can also write your SQL query manually and use
qx::dao::call_query() or
qx::dao::execute_query() functions.
You can also use directly the QtSql module if you prefer because QxOrm library is based on QtSql.
About PostgreSQL table inheritance, I would recommend to :
1- define your tables with pgAdmin or another tool ;
2- donwload and execute QxEntityEditor application ;
3- try the QxEntityEditor import plugin to load your tables into a QxEntityEditor project ;
4- then you can export it to a C++/Qt project, and see how classes are mapped to the inherited tables.