XPath or SQL2?

[ariellea4070516]

Which is the recommend query language in AEM's current lifecycle: XPath or SQL2?

One HelpX article (with a timestamp of 2018 but that does not appear to have been updated since 6.3) says XPath over SQL2

Oak Queries and Indexing

While a HelpX resource with an earlier timestamp of 2017 says SQL2 over XPath

Describing the JCR model in Adobe Experience Manager | at 2:15

Which is the correct recommendation and why?

Thanks in advance!

[Jörg_Hoh · Accepted solution]

At the moment there is no clear recommendation. Both are supported and the performance of both is comparable. From a specification point of view XPath is deprecated, but the Oak team made the statement at some occassions that they don't plan to drop XPath support.

Jörg

[ariellea4070516]

Thanks, Jörg!