How to make a SQL query with a variable number of parameters?

Question

WordPress

You need to make a SELECT of the form:

SELECT id,age
FROM users
WHERE age=22 [and gender='m' and ...]

Options may be missing. All combinations do not really want to copy-paste. Which way to look (in Go ) to write normally?

Answer 1

I've done everything.
It turns out that two closing tags are missing in the header.
It remains to be seen why they disappeared.
The main thing is that it works.
I will remember this lesson for a long time.

Answer 2

https://github.com/Masterminds/squirrel

Answer 3

form a query in any convenient way, put the data into an array of type
var data []interface{}
and then
if r, err = tx.Query(query, data...
) use the syntax for applying an array as a set of parameters

Answer 4

https://github.com/avelino/awesome-go#database Choose from here under `SQL query builder, libraries for building and using SQL.` the library that suits you.