<@U1DCM39JR>: for DATE_ADD with days we wrote : `...
# exposed
@supaham: for DATE_ADD with days we wrote :
Copy code
class DateAddDays(val dateExp: Expression<DateTime>, val addDays: Expression<Int?>) : Expression<DateTime>(){
    override fun toSQL(queryBuilder: QueryBuilder): String {
        return "DATE_ADD(${dateExp.toSQL(queryBuilder)}, INTERVAL IFNULL(${addDays.toSQL(queryBuilder)}, 0) DAY)"

fun Expression<DateTime>.addDays(days: Expression<Int?>) = DateAddDays(this, days)
and you can use it in Exposed expressions:
Table.select { DateColumn eq OtherDateColumn.addDays( ColumnWithDaysCountToAdd ) }