squirrel issues

Select in where clause

7

This is more like a question than an issue. Is there a way to use a select sub query inside the `WHERE IN`? something like: `WHERE post.id IN ( SELECT...

saito-sv

Add GetOrderBy and RemoveOrderBy to get and remove the OrderByParts from the query

1

It is useful to be able to reset the order-by in some situations, or retrieve the order by. Our case is simple enough, we have a generic function that executes...

Cofgren

Where clause compare column of table

5

The update query is `UPDATE videos v SET channel = $1 FROM channels c WHERE c.channel_id = $2 AND v.channel_id = $3` Builder ``` var channelID int query, args, _...

bohrasankalp

Request: parse slice of floating-point to vector

1

I am using squirrel to build my sql command with postgres,. Since I starting to use pgvector extension, I need to generate sql command with vector like: ```sql SELECT *...

kevin19930919

insert using select that has a non string column

Hello, DB Fiddle for the example: https://www.db-fiddle.com/f/wpNmAGWfjWoZS4goc8EWfc/0 I was trying to generate a SQL like - ``` INSERT INTO test(id, data_id, type, deleted_at) SELECT 10, data_id, type, deleted_at FROM test...

shreyaspurohit

Inserting array value on postgresql

I want to insert array to the table , the following code does not work. ``` insertMap := map[string]interface{}{ order_column_id: input.OrderID, order_column_assigned_users: []string{userID}, } query, args, err := sq.Insert(ORDER_TABLE). SetMap(insertMap)....

dennissetiawan

Limit and Offset use prepare statement placeholder

3

Can `Limit()` and `Offset()` functions make a placeholder for prepare statement? Use squirrel v1.5.4 the result: ``` sql, args, err := squirrel.Select("id").From("mytable").Where("id < ?", 100).Limit(10).Offset(20).ToSql() // output sql: SELECT id...

fengxuway