When using SQL, the IN statement does not work in the SELECT section of a query

Elastic Stack Elasticsearch
1

ES Version: 7.8

I’m trying to run the following in SQL Workbench, and one query works, but the other one does not…any thoughts?

Successful:

SELECT
  *
FROM
  my_index
WHERE
  a.b IN ('115')

Failure:

SELECT
  a.b IN ('115') AS 'FOO'
FROM
  my_index
2

What is that syntax?
What are you trying to achieve?

3

This simply is an invalid syntax. See Elastic's supported syntax or any other SQL tutorials.