squirrel icon indicating copy to clipboard operation
squirrel copied to clipboard

Fluent SQL generation for golang

Results 94 squirrel issues
Sort by recently updated
recently updated
newest added

Add support for joins on `DeleteBuilder`

So far I *really* like squirrel but something that annoys me tremendously is that lack of a SctructScan. What are the possibilities of getting StructScan added?

I'm trying to dynamically generate Create table/view statements for presto in my application, based on JSON-files located on S3. Are there any plans for a CreateBuilder in squirrel? I'm also...

This allows us to replace all 'Columns' with a fresh set

Hello! Thanks for Squirrel and I know it is "complete" but I'd consider this perhaps a bug, or at least it could be documented. When combining lots of subqueries into...

Calling `query.Distinct().Distinct()` results in the `DISTINCT` option being applied twice, which is invalid SQL. See the playground snippet here: https://play.golang.org/p/9qwFGj1jRWx ```golang builder := sq.StatementBuilder.PlaceholderFormat(sq.Dollar) q1 := builder.Select("foo").From("bar").Distinct() sql, _, _...

This would allow us to join against a subquery against another table with conditional where clauses. Otherwise, we need to join against the entire table, which does not satisfy our...

Minimal working example ``` package main import ( "fmt" sq "github.com/Masterminds/squirrel" ) func main() { var ids []uint64 query, args, err := sq.Select("sub_account_id").From("someTable").Where(sq.Eq{"id": ids}).ToSql() fmt.Println(query, args, err) } ``` Ideally...

I posted an issue here : https://stackoverflow.com/questions/65858504/postgres-bigint-value-not-being-created-or-updated-with-golang-and-sqlx Here is the content. I am doing this : Note : Request is generated with **squirrel** ```go // Prepare query qb := sq.Update(d.table)....

Hi there, I am trying to do the exact same thing that is shown in the FAQs https://github.com/Masterminds/squirrel#faq ``` var metricMatcher =sq.Or{ sq.Eq{"col1": 1, "col2": 2}, sq.Eq{"col1": 3, "col2": 4}}...