Changes to Qt SQL

Qt 6 is a result of the conscious effort to make the framework more efficient and easy to use.

We try to maintain binary and source compatibility for all the public APIs in each release. But some changes were inevitable in an effort to make Qt a better framework.

In this topic we summarize those changes in Qt SQL, and provide guidance to handle them.

The QSqlQuery class

boundValues() Signature

The return type for boundValues() has been changed from QMap<QString, QVariant> to a QVariantList. The order can be relied upon so it will be in the order of the binding in the prepared query. Change code like the following:

QMap<QString, QVariant> values = boundValues();
int id = values[":id"].value().toInt();

QList<QVariant> values = boundValues().values();
int id = values.at(0).toInt();

to:

QList<QVariant> values = boundValues().values();
int id = values.at(0).toInt();