在qt中执行自己的sql函数

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("database.db");
if (!db.open()) {
    qDebug() << "Failed to open database";
    return;
}

QSqlQuery query;
QString createFunctionQuery = "CREATE FUNCTION myFunction(param1 INT, param2 TEXT) "
                              "RETURNS INT "
                              "BEGIN "
                              "    -- Function logic here "
                              "END";
if (!query.exec(createFunctionQuery)) {
    qDebug() << "Failed to create function";
    return;
}

QSqlQuery query;
QString selectQuery = "SELECT myFunction(1, 'example')";
if (!query.exec(selectQuery)) {
    qDebug() << "Failed to execute query";
    return;
}
if (query.next()) {
    int result = query.value(0).toInt();
    qDebug() << "Function result: " << result;
}