Limit and Offset use prepare statement placeholder
Author: fengxuwayCreated Apr 20, 2023Updated Apr 25, 2025
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 FROM mytable WHERE id < ? LIMIT 10 OFFSET 20
args: [100]
// Expect output
sql: SELECT id FROM mytable WHERE id < ? LIMIT ? OFFSET ?
args: [100, 10, 20]Source: Masterminds/squirrel