squirrel
squirrel copied to clipboard
Fluent SQL generation for golang
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}}...