ADQL < IVOA < TWiki

IVOA Web>IvoaDAL>ADQL (2023-03-08, GregoryMantelet) (raw view)

---++ Astronomical Data Query Language

The Astronomical Data Query Language (ADQL) is the language used by the IVOA to represent astronomy queries posted to VO services. ADQL is based on the Structured Query Language, especially SQL 92; special restrictions and extensions have been defined in order to support generic and astronomy specific operations.

---+++ Current recommendation

The current IVOA Recommendation is [[http://www.ivoa.net/documents/ADQL/2.0][ADQL-2.0]] (30 October 2008).

[[ADQL-2_0-Next][ADQL-2.0-Next]]<span style="background-color: transparent;"> page collects proposed features and notes while developing the next revision of the specification. </span> [[ADQL-2_0-Errata]]<span style="background-color: transparent;"> keeps track of the Errata status for this specific version of the recommendation.</span>

[[ADQL-2_1-Next][ADQL-2.1-Next]] page collects proposed features and notes while developing the next revision of the specification. [[ADQL-2_0-Errata][<br />]]

---+++ ADQL-2.1 Proposed Recommendation

The DAL group are working on developing the next version (2.1) of  the ADQL specification.

The latest version of the specification is available as HTML and PDF at  [[https://www.ivoa.net/documents/ADQL/20210528/index.html][PR-ADQL-2.1-20210528]] (28 May 2021).

---++++ Document source

The source code for the document can be found online in the [[https://github.com/ivoa-std/ADQL][ADQL GitHub repository]].

The following command can be used to checkout a local copy of the document source.
<verbatim>
    git clone https://github.com/ivoa-std/ADQL.git</verbatim>

---++++ BNF grammar validation effort

At the [[http://www.adass2016.inaf.it/index.php/13-ivoa-interop][October 2016 interop in Trieste]] the DAL group decided to [[http://wiki.ivoa.net/internal/IVOA/InteropOct2016DAL/adql-20161022-002.pdf#5][delay putting the ADQL 2.1 working draft forward for the next stage of review]] because there were questions about the validity of the [[https://en.wikipedia.org/wiki/Backus%E2%80%93Naur_form][Backus–Naur form]] (BNF) definition of the language grammar included in the specification.

Prior to this, the BNF definition of the language grammar has been treated as a human readable resource that was interpreted manually by people developing ADQL parser implementations.

The October 2016 decision added a new requirement that the BNF definition of the language grammar needed to be machine readable and had to be validated against a set of standard queries.

In order to accomplish this, the [[https://github.com/ivoa/lyonetia/][Lyonetia GitHub project]] has been set up to develop the tools and test data needed to create a machine readable version of the grammar.

To follow and contribute to this work please refer to the [[https://github.com/ivoa/lyonetia#project-plan][project plan]].

---+++ Previous versions
   * <span style="background-color: transparent;">DAL PR (2021-05-28): [[https://www.ivoa.net/documents/ADQL/20210528/index.html][PR-ADQL-2.1-20210528]]</span><span style="background-color: transparent;"> (git commit [[https://github.com/ivoa-std/ADQL/commit/0d5911f763f0e88bedf907559d009b61b4e02172][0d5911f]] or git tag [[https://github.com/ivoa-std/ADQL/tree/v2.1_20210528-pr][v2.1_20210528-pr]])</span>
   * DAL Internal WD (2017-11-29): [[%ATTACHURL%/WD-ADQL-2.1-20171129.pdf][WD-ADQL-2.1-20171129]] (svn revision 4594)
   * DAL Internal WD (2017-10-24): [[%ATTACHURL%/WD-ADQL-2.1-20171024.pdf][WD-ADQL-2.1-20171024]] (svn revision 4555)
   * DAL Internal WD (2017-10-23): [[%ATTACHURL%/WD-ADQL-2.1-20171023.pdf][WD-ADQL-2.1-20171023]] (svn revision 4544)
   * DAL Internal WD (2016-05-02): [[%ATTACHURL%/WD-ADQL-2.1-20160502-05.pdf][WD-ADQL-2.1-20160502]] (svn revision 3385)
   * DAL Internal WD (2015-06-01): [[%ATTACHURL%/WD-ADQL-2.1-20150601.pdf][WD-ADQL-2.1-20150601]] (svn revision 2983)

---++ Associated projects

   * [[https://www.ivoa.net/documents/udf-catalogue/20210310/][UDF Catalogue]] Collections of IVOA User Defined Functions
   * [[https://github.com/ivoa/cosmopterix][Cosmopterix]] Docker containers for common database platforms.
   * [[https://github.com/ivoa/lyonetia/][Lyonetia]] project to validate language grammar.
   * [[AdqlFunctionPrefixes][ADQL function name prefixes]] to avoid name conflicts.

<!--
      * Set ALLOWTOPICRENAME = IVOA.TWikiAdminGroup
-->

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who
pdf	WD-ADQL-2.1-20150601.pdf	r1	manage	562.6 K	2015-06-05 - 14:25	MarcoMolinaro
pdf	WD-ADQL-2.1-20160502-01.pdf	r1	manage	567.6 K	2016-05-02 - 06:43	DaveMorris
pdf	WD-ADQL-2.1-20160502-02.pdf	r1	manage	595.1 K	2016-05-02 - 07:18	DaveMorris
pdf	WD-ADQL-2.1-20160502-03.pdf	r1	manage	568.1 K	2016-05-02 - 07:24	DaveMorris
pdf	WD-ADQL-2.1-20160502-04.pdf	r1	manage	568.4 K	2016-05-02 - 15:27	DaveMorris
pdf	WD-ADQL-2.1-20160502-05.pdf	r1	manage	568.3 K	2016-05-02 - 17:49	DaveMorris
pdf	WD-ADQL-2.1-20160502.pdf	r1	manage	567.6 K	2016-05-02 - 06:32	DaveMorris
pdf	WD-ADQL-2.1-20171023.pdf	r1	manage	563.8 K	2017-10-24 - 12:42	DaveMorris
pdf	WD-ADQL-2.1-20171024.pdf	r1	manage	711.3 K	2017-10-25 - 03:03	DaveMorris
pdf	WD-ADQL-2.1-20171129.pdf	r1	manage	746.9 K	2017-11-29 - 16:38	DaveMorris
pdf	WD-ADQL-2.1-20171208.pdf	r3 r2 r1	manage	747.0 K	2017-12-08 - 16:02	DaveMorris