In Hybris, there is a query language called “above-SQL,” which operates on Hybris objects, not database tables. It’s needed to support multiple DBMS, from Oracle to MySQL, and also so that programmers stop thinking in terms of tables – this provides certain flexibility for further development of Hybris.
FlexibleSearch is fairly well-documented, yet I managed to find some unknown aspects that 99% of developers are not aware of. They are useful in different ways: some can be used in projects, while others, if applied accidentally without understanding the reasons, can lead to days of troubleshooting. This article is about these secrets and undocumented features of FlexibleSearch.
https://hybrismart.com/2016/11/06/what-you-dont-know-about-flexiblesearch/
Hi, I'm Rauf Aliev. 