Description:
Currently, when using the select, exec, namedSelect, and namedExec methods with an "IN" clause, we need to manually call a function to handle the parameter expansion. This can be cumbersome and less user-friendly compared to other ORM libraries like GORM, which automatically handle this.
It would be great if SQLx could automatically support the "IN" clause and parameter expansion in these methods, making it more convenient and easier to use.
Example:
Current usage:
query, args, err := sqlx.In("SELECT * FROM users WHERE id IN (?)", []int{1, 2, 3})
if err != nil {
// handle error
}
query = db.Rebind(query)
rows, err := db.Query(query, args...)Desired usage:
rows, err := db.Select("SELECT * FROM users WHERE id IN (?)", []int{1, 2, 3})This enhancement would improve the developer experience and make SQLx more competitive with other ORM libraries.
Description:
Currently, when using the select, exec, namedSelect, and namedExec methods with an "IN" clause, we need to manually call a function to handle the parameter expansion. This can be cumbersome and less user-friendly compared to other ORM libraries like GORM, which automatically handle this.
It would be great if SQLx could automatically support the "IN" clause and parameter expansion in these methods, making it more convenient and easier to use.
Example:
Current usage:
Desired usage:
This enhancement would improve the developer experience and make SQLx more competitive with other ORM libraries.