Get full text of expression

[aplarsen]

In a select statement, reconstituting any expression that isn't aliased must take some recursion to drill down and glue it back together. Up at the statement[i].result[i] level, would it be too much to ask to see the full expression here?

For example, in this query:

select
    first_name || ' ' || last_name,
    grade_level
from
    students

I'd love to see this as the return:

{
    "statement": [
        {
            "result": [
                {
                    "type": "expression",
                    **"fullText": "first_name || ' ' || last_name",**
                    "left": "etc"
                    "right": "etc"
                },
                {
                    "type": "column",
                    "name": "grade_level"
                }
            ]
        }
    ]
}

[karlb]

If #23 gets done, you might be able pass the expression to the query generator in order to get the whole expression as a string.

[aplarsen]

Ooh, definitely. I like that.