A modern programming language that makes developers happier.

kotlinlang

I'm trying to use `DATE_ADD` (<https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-add>) in an sql statement with sqldelight, but sqldelight complains `'(', ')', '.', &lt;binary like operator real&gt;, BETWEEN or IN expected, got '6'`
The used SQL code:  `date_add(current_date() , interval 6 month)`
Am I doing something wrong or is there a workaround for such a case?

needs to be added to the dialect: <https://github.com/cashapp/sqldelight/blob/sql-psi-dev/dialects/mysql/src/main/kotlin/app/cash/sqldelight/dialects/mysql/MySqlTypeResolver.kt#L49>

Ah okay. Workaround for the moment (if someone else comes along the problem)
```makedate(year(current_date()), dayofyear(current_date()) + 183)```
It's of course not accurate, but at least enough for me.

:+1: can you file a bug on sqldelight for this?

<https://github.com/cashapp/sqldelight/issues/2969>