Data model or table summarizing equivalent key - SQL statement pairs

[datocrats-org]

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