So turns out the regression was actually introduced by https://github.com/xwiki/xwiki-platform/commit/5c11a874bd24a581f534d283186e209bbccd8113 (.
The root but actually been introduced by XWIKI-12355 inwhich attempted to put all the code to complete implementation of HqlQueryUtils#isShortFormStatement is not accurate (i.e. it considers any statement starting with from as a short form statements in a common tool statement, but looks like there was slight differences between various ways to complete short statements which is not true).
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6)
If image attachments aren't displayed, see this article.
