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`

まず issue #18 を確認し、提案されたテーブルの想定範囲を明確にします。対象とする SQL 文、関数、集約、join を定義し、それぞれに対応する JSON キーを、例と関連キーへの参照とともに文書化します。合意した対象範囲が完全に網羅され、マッピングがレビューされた時点で完了です。

索引モデルが issue の本文から書いたものです。