How about readOnly for sql query?

[linux-china]

For some case, I should check sql that is a select statement. How about add readonly for query?

public fun DataFrame.Companion.readSqlQuery(
    dbConfig: DbConnectionConfig,
    sqlQuery: String,
    limit: Int = DEFAULT_LIMIT,
    inferNullability: Boolean = true,
    dbType: DbType? = null,
    strictValidation: Boolean = true,
): AnyFrame {
    DriverManager.getConnection(dbConfig.url, dbConfig.user, dbConfig.password).use { connection ->
        //    conn.isReadOnly = true
        //    conn.autoCommit = false
        return readSqlQuery(connection, sqlQuery, limit, inferNullability, dbType, strictValidation)
    }
}

Or to add readonly for DbConnectionConfig?

[zaleslaw]

Thanks for your suggestion, we will consider this idea in the next Beta release