goqu

goqu copied to clipboard

Removal of double quotes around table name

3

**Is your feature request related to a problem? Please describe.** I am facing an issue with double quotes for the table name. When executing a query I always get Error...

psrikanth554

how to add Identifier to struct select

1

type A struct { C string D string } type B struct { C string D string } type AB struct { A B } goqu.From("a").Select(&AB{}).Join("b") how to generate sql...

RaymondReddington

How to SELECT "col" IS NOT NULL AS "alias" ?

1

Is there a way to alias a boolean expression in the select column list? I think what I want is basically: ```go db.From("foo").Select(goqu.I("foo.bar").IsNotNull().As("have_bar") ``` But type exp.BooleanExpression does not implement...

makholm

Is it possile to generate sql like ">=? and <?" only with goqu.Ex?

2

Is it possile to generate sql like `">=? and

lauthrul

Sql server using Limit() with Distinct() wrong order

1

**Describe the bug** when distinct() and limit(1) is used together, sql generated is SELECT TOP (1) DISTINCT **To Reproduce** Use distinct and limit clause together with dialect sqlserver .Distinct().Limit(1) **Expected...

CKehToh

Sql server use double ' ('') to escape '

1

XIELongDragon

window function postgres filter

1

Hi great author:) **Dialect** - [ ] postgres how make filter for this window function?, for example SUM(adi.amount) FILTER (WHERE ad.document_status = 'pending') as unpaid_document_sum Thanks Ales

talpa

where Exists (select)

3

add please function exists **Dialect** - [x] postgres - [x] mysql - [x] sqlite3 **Additional context** Add any other context or screenshots about the feature request here.

talpa

No means of omitting zero values, generating useless INSERT queries

3

## Issue Summary **Dialect: `sqlite3`**: However, this issue is not related to the dialect. Using the `struct` format of `goqu` for `INSERT`s lead to... unusable queries, should you be (DRY)...

AlbinoGeek

Is OrderBy helper function available

1

couldn't find docs for OrderBy how do we generate queries that require OrderBy

ashu8912