ADQL21RFC < IVOA

---++ ADQL 2.1 Proposed Recommendation: Request for Comments

<br />%TOC{depth="2"}%

---

ADQL defines an SQL-like grammar adapted for astronomical purpose. It is especially used by the <a href="TableAccess" target="_blank">TAP</a> (Table Access Protocol) standard.

Latest version of ADQL can be found at:
   * https://www.ivoa.net/documents/ADQL/20230418/index.html

---+++ Reference Interoperable Implementations
   * <a href="https://soft.g-vo.org/dachs" target="_blank">DACHS</a>
   * <a href="https://github.com/gmantele/vollt/tree/adql2.1" target="_blank">VOLLT/ADQLLib (branch adql2.1)</a>

---+++ Implementations Validators

Two ADQL parsing validators available in the GitHub repository named <a href="https://github.com/ivoa/lyonetia" target="_blank">Lyonetia</a>:
   * One based on DACHS: <a href="https://github.com/ivoa/lyonetia/tree/master/src/adql/gavo" target="_blank">src/adql/gavo</a>
   * One based on VOLLT: <a href="https://github.com/ivoa/lyonetia/tree/master/src/adql-validator" target="_blank">src/adql-validator</a>
Both validators work offline and with no assumption on a specific database schema.

A GitHub CI workflow is set up in this repository. It validates all test queries available in the <a href="https://github.com/ivoa/lyonetia/tree/master/src/adql/ivoa" target="_blank">src/adql/ivoa</a> directory thanks to the ADQL validator based on VOLLT.

Two badges are visible on top of the <a href="https://github.com/ivoa/lyonetia/blob/master/README.md" target="_blank">README.md</a> document. The first one (named "Validator test") indicates whether the ADQL validator based on VOLLT compiled successfully or not. The second one (named "ADQL Validation) indicates whether all test queries passed or not. An HTML report is visible by clicking on this second badge (after clicking on the badge, click on the "Master" page to see it). It shows which test file run and which tests failed.

---
---

---++ Comments from the IVOA Community during RFC/TCG review period: %RED%RFC_start_date - RFC_end_date%ENDCOLOR%

The comments from the TCG members during the RFC/TCG review should be included in the next section.

In order to add a comment to the document, please edit this page and add your comment to the list below in the format used for the example (include your Wiki Name so that authors can contact you for further information). When the author(s) of the document have considered the comment, they will provide a response after the comment.

Additional discussion about any of the comments or responses can be conducted on the WG mailing list. However, please be sure to enter your initial comments here for full consideration in any future revisions of this document

   * Sample comment by TWiki.WikiName
      * Response (by TWiki.WikiName)

---
---

---++ Comments from TCG member during the RFC/TCG Review Period: %RED%TCG_start_date - TCG_end_date%ENDCOLOR%

WG chairs or vice chairs must read the Document, provide comments if any (including on topics not directly linked to the Group matters) or indicate that they have no comment.

IG chairs or vice chairs are also encouraged to do the same, althought their inputs are not compulsory.

---+++ TCG Chair & Vice Chair

---+++ [[IvoaApplications][Applications Working Group]]

---+++ [[IvoaDAL][Data Access Layer Working Group]]

---+++ [[IvoaDataModel][Data Model Working Group]]

---+++ [[IvoaGridAndWebServices][Grid & Web Services Working Group]]

---+++ [[IvoaResReg][Registry Working Group]]

---+++ [[IvoaSemantics][Semantics Working Group]]

---+++ [[IvoaDCP][Data Curation & Preservation Interest Group]]

---+++ [[IvoaEducation][Education Interest Group]]

---+++ [[IvoaKDD][Knowledge Discovery Interest Group]]

---+++ [[IvoaOps][Operations Interest Group]]

---+++ [[IvoaRadio][Radio Astronomy Interest Group]]

---+++ [[IvoaSS][Solar System Interest Group]]

---+++ [[IvoaTheory][Theory Interest Group]]

---+++ [[IvoaVOEvent][Time Domain Interest Group]]

---+++ [[IvoaStdsDocsProc][Standards and Processes Committee]]

---

---++ TCG Vote : %RED%Vote_start_date - Vote_end_date%ENDCOLOR%

If you have minor comments (typos) on the last version of the document please indicate it in the Comments column of the table and post them in the TCG comments section above with the date.

| Group | Yes | No | Abstain | Comments |
| TCG | | | | |
| Apps | | | | |
| DAL | | | | |
| DM | | | | |
| GWS | | | | |
| Registry | | | | |
| Semantics | | | | |
| DCP | | | | |
| Edu | | | | |
| KDIG | | | | |
| Ops | | | | |
| Radio | | | | |
| SSIG | | | | |
| Theory | | | | |
| TD | | | | |
| &lt;nop&gt;StdProc | | | | |

---

<br /> &lt;!--&lt;/p&gt; &lt;ul&gt; &lt;li&gt; &lt;ul&gt; &lt;li&gt; Set ALLOWTOPICRENAME =&lt;span class="WYSIWYG_PROTECTED"&gt; IVOA.TWikiAdminGroup &lt;/span&gt; &lt;/li&gt; &lt;/ul&gt;&lt;/li&gt; &lt;/ul&gt;--&gt;
This topic: IVOA > WebHome > IvoaDAL > ADQL > ADQL-2_1-Next > ADQL21RFC
Topic revision: r14 - 2023-04-18 - GregoryMantelet