I could not find any discussion of this topic, so here's my question.
I know I can set the column heading with the AS keyword. The values that I can set seem to be limited to literals from the Cypher code, though the syntax does not require quotes. (In fact, since it doesn't allow quotes, I can't have column names with spaces, leading numbers don't work, etc.). So I can do this:
... return s.Value as NewYork ...
but not:
... return s.Value as 'New York' ...
Is there any way to set the AS column name to the value of a parameter? I do not see how, because the AS value is taken literally, not resolved. I would like to do this and have the column heading come out as whatever city was provided. In other words, a more parameterized report output format:
with 'New York' as location ...
some logic that provides values for rows where some attribute is New York
... return s.Value as location ...
Currently, I have to show the attribute value as another column, which takes up space.
... return s.City as Location, s.Value as Value...
If the column heading could be parameterized, it would be clear that the whole report relates to New York values, saving a column. (In my real case, multiple columns because it's a comparison report.)
