goqu icon indicating copy to clipboard operation
goqu copied to clipboard

SQL builder and query library for golang

Results 142 goqu issues
Sort by recently updated
recently updated
newest added

Currently, the `init()` of mysql dialect puts `false` on the feature of `WITH CTE`, although mysql 8.0 does support it. I think it's safe to turn the dialect support on...

**Is your feature request related to a problem? Please describe.** How can I use table hints with sqlserver dialect? **Describe the solution you'd like** I would like to create a...

Thoughts on adding support for oracle databases? The current implementation can't do aliases correctly for Oracle. Using As() for table aliasing in the FROM statement uses the AS keyword, which...

Hi! I need to build following query: ```sql DELETE FROM table1 t1 USING (SELECT id FROM table2) AS t2 WHERE t1.tab2_id = t2.id ``` But DeleteDataset does not have method...

**Describe the bug** SQLite3 dialect is declared as not supporting `RETURNING` clauses https://github.com/doug-martin/goqu/blob/31d438d38230118d377f11cfaad9627aa3a23864/dialect/sqlite3/sqlite3.go#L13 but it actually does. > The RETURNING syntax has been supported by SQLite since version 3.35.0 (2021-03-12)....

Closes: https://github.com/doug-martin/goqu/issues/358

Apologies if this is answered somewhere, I tried searching and couldn't find anything. If I wanted to generate a nested select statement/select subquery similar to the following: ```sql SELECT *...

**Describe the bug** The `skipinsert` and `skipupdate` tags are ignored for struct fields. **To Reproduce** ``` type Foo struct { A string `db:"a"` Bar Bar `db:"bar" goqu:"skipinsert,skipupdate"` } type Bar...