squirrel
squirrel copied to clipboard
Masterminds
Fluent SQL generation for golang
Hi and thanks for your great jobs. It's nice to have such a tool to write sql queries nicely, you do a great job for maintenability. I'm in a situation...
Hey, is it possible to build sub query (aka nested query) and pass it into where condition? Raw query: ```sql SELECT * FROM table1 LEFT JOIN ... LEFT JOIN ......
Fix the document for the `RemoveLimit` function to clearly describe its purpose.
Added some tests and a fix for generating union queries.
As a follow-up to the previous issue #83, I would like to know how to handle the suffix approach for updating a conflict when there is a multi-row insert statement.
I'm trying to recreate this query with squirrel: ``` SELECT c.userID, c.name, o.orderID FROM users as c join order as o ON c.userID = o.userID where orderID IN ('a', 'b');...
I noticed something weird why can't we use ? in column name? `sql, args, err := sb.Select("test").Where("y = ?", 2).ToSql()` OK but `sql, args, err := sb.Select("test").Where("? = ?","y", 2).ToSql()`...
Is there a way to generate a CTE? I didn't see anything in docs mentioning this. I'm using PostgreSQL.
Same as #357 , but with different source branch - Added CREATE, DROP. - Extended SELECT for Yandex Database YQL.
