sqlite3 dialect incorrectly states RETURNING clause isn't supported

doug-martin / goqu

SQL builder and query library for golang

http://doug-martin.github.io/goqu/

MIT License

2.37k stars 207 forks source link

sqlite3 dialect incorrectly states RETURNING clause isn't supported #432

Open yktoo opened 1 day ago

yktoo commented 1 day ago

The implementation of the sqlite3 dialect (dialect/sqlite3/sqlite3.go) configures opts.SupportsReturn = false. However, the SQLite driver does support RETURNING (see docs), which can easily be verified by dropping to the default dialect while using an SQLite3 database.

Dialect:

[ ] postgres
[ ] mysql
[x] sqlite3

Func86 commented 1 day ago

Addressed in https://github.com/doug-martin/goqu/commit/7ff091d4521d0ee17a0b4abc01a200091cfc208f but not released.