go-jet

Yeah, it makes sense.

MySQL optimizer hints included in v2.9.0 release.

Hi @apawelec. Multiset operator seems like an interested idea. :eyes:

To pass a custom column list to insert or update query, you can use `ColumnList`: https://github.com/go-jet/jet/blob/6babd43e3a1af2a7bdff78c32423d0c5e601a644/tests/postgres/update_test.go#L288-L294 I'll add this to wiki.

We can't use `ColumnList` in definition because `UPDATE` should work with single `Column`, comma separated list of columns and `ColumnList`. Now, we could expose `jet.Column`, but I don't see how...

Yeah, it seems `jet.Rows` is not exposed. Contributions are welcomed. `Statement` is exposed [here](https://github.com/go-jet/jet/blob/master/postgres/types.go).

Hi @tooolbox, MS SQLServer will be added eventually, but it is not planned in near term. Open source libraries like sqllite will be supported next.

Hi @masterkidan. Json expressions are currently not supported. You'll have to use [raw expressions](https://github.com/go-jet/jet/wiki/Expressions#raw-expression): ```golang .WHERE(RawBool("info ->> 'version' > excluded.info->>'version'")) ```

Hi @kblomster . Yeah, it seems those functions are missing for MySQL. Wiki update PR also welcomed.

Hmm, it looks like they are missing for SQLite as well.