Is there a way to wrap a constant as a query? i.e.

SELECT 1

this is what I did:

object One : Expression<String>() {
    override fun toQueryBuilder(queryBuilder: QueryBuilder) = queryBuilder { append("1") }
}

There is

intLiteral

and

intParam

functions for that, but you have to declare some fake table, like DUAL in Mysql.

object DualTable : Table("DUAL") 

DualTable.slice(intLiteral(1)).selectAll()

@tapac it looks like the

Query

object will always append

FROM

, which I believe returns the literal value for each row. I am guessing that there is no object that adheres to

Query

that doesn't use

FROM

😬