go-sqlbuilder

go-sqlbuilder copied to clipboard

ON DUPLICATE KEY UPDATE

17

Torwang1

Add insert ignore support for postgres and sqlite

1

### Summary Add insert ignore support for postgres and sqlite. For pg, this is `ON CONFLICT DO NOTHING`, for sqlite it's `INSERT OR IGNORE` - https://www.postgresql.org/docs/current/sql-insert.html - https://www.sqlite.org/lang_insert.html ### Testing...

zhongr3n

* Add CQL flavor. * Add support for CQL argument compilation. * Adopt substests for interpolation tests. * Add support for CQL interpolation. * Add support for CQL blobs: https://docs.datastax.com/en/cql-oss/3.x/cql/cql_reference/blob_r.html...

SpencerC

How to write SELECT EXISTS queries?

1

I am attempting build a query of the form ```sql SELECT EXISTS (SELECT 1 FROM table WHERE ... ) ``` Without resorting to writing raw sql using `sb.SQL()`, is there...

cyberbeast

need is WITH statement?

3

I can add WITH statement for this lib, you think this need?

MigAru

Interpolating arguments for Clickhouse have not correct format

2

The format is not '?' It is defined in https://clickhouse.com/docs/en/interfaces/http#cli-queries-with-parameters

astudnev

Add benchmark cases

2

Per #94, add some cases for performance.

huandu

Benchmarks against Masterminds/squirrel

7

Can we have benchmarks against other builder like [squirrel](https://github.com/Masterminds/squirrel)

yogibaba

Support recursive CTEs

5

Support using the `WITH RECURSIVE ...` keywords for recursive CTEs.

arikkfir

Add support for recursive CTEs

1

This change adds support for recursive CTEs by introducing the `Recursive()` method to `CTETableBuilder`. This method is automatically called by the existing `CTETable(name, cols)` function, but can also be called...

arikkfir