Passing parameters to a query

Elastic Stack Serverless

Using values in a query condition, for example, or in a HAVING statement can be done "inline", by integrating the value in the query string itself:

 POST /_sql?format=txt {
	"query": "SELECT YEAR(release_date) AS year FROM library WHERE page_count > 300 AND author = 'Frank Herbert' GROUP BY year HAVING COUNT(*) > 0"
}

or it can be done by extracting the values in a separate list of parameters and using question mark placeholders (?) in the query string:

 POST /_sql?format=txt {
	"query": "SELECT YEAR(release_date) AS year FROM library WHERE page_count > ? AND author = ? GROUP BY year HAVING COUNT(*) > ?",
	"params": [300, "Frank Herbert", 0]
}