Data model or table summarizing equivalent key - SQL statement pairs

I would like to work on #18 and in order to do that I think I need to build a table of equivalent keys in your JSON output and their SQL equivalent. I want to start on something simple select statments with a few types of functions, aggregations, and joins. Is there any existing table showing descriptions of the equivalent SQL statements, where any related content can be found in the JSON tree?

| Key | description with example and related keys |
|- |-|
| CompoundIdentifier | tableAlias.columnName with `[0]['value'] = "tableAlias"` and `[1]['value'] = "columnName"` separated by `.` with the first portion of the identifier corresponding to a table alias found in `join.#.relation.Table.alias.name.value`

Start by reviewing issue #18 and clarifying the intended scope for the proposed table. Define which SQL statements, functions, aggregations, and joins it should cover, then document each equivalent JSON key with an example and related-key references; done when the agreed coverage is complete and the mappings are reviewed.

Written by the indexing model from the issue text.