SQLDelight如何允许未识别的表达式？

可以使用customSql函数来处理SQL语句中未识别的表达式。

示例代码：

private val UNRECOGNIZED_EXPRESSION = AstTransformExpression(object : AstTransformer {
    override fun transformAbs(abs: Abs) = error()
    override fun transformAdditiveExpr(additiveExpr: AdditiveExpr) = error()
    override fun transformAndExpr(andExpr: AndExpr) = error()
    override fun transformBetween(between: Between) = error()
    // 其他方法省略，仅保留了部分方法
    override fun transformTuple(tuple: Tuple) = error()
    override fun transformUnaryOp(unaryOp: UnaryOp) = error()
    override fun transformWhen(whenExpr: When) = error()

    private fun error() {
        throw IllegalArgumentException("Unsupported operation!")
    }
})

fun sqlQuery(handler: Any) = object : Any() {
    val name = "("
    operator fun String.unaryPlus() {
        val newHandler = UNRECOGNIZED_EXPRESSION.transformHandler(handler)
        QueryHandlerWrapper(query = StringBuilder(name).append(this).append(")").toString(), columns = emptyList()) { cursor ->
            newHandler.handle(cursor)
        }
    }
}

fun customSql(sql: String) = sqlQuery { cursor: android.database.Cursor -> longArrayOf() } + sql

然后可以使用customSql函数来执行未识别的表达式：

val customQuery = customSql("SELECT * FROM my_table WHERE $someCondition OR $otherCondition")

val result: List<MyModel> = database.myModelQueries.custom(customQuery).executeAsList()