How does Flexible Search query translate to SQL query in Hybris?

 https://stackoverflow.com/questions/47257092/how-does-flexible-search-query-translate-to-sql-query-in-hybris

private static final Logger LOG = Logger.getLogger(ExampleClass.class);

@Resource
private FlexibleSearchService flexibleSearchService

......

FlexibleSearchQuery query = new FlexibleSearchQuery(query_string);
TranslationResult result = flexibleSearchService.translate(query);
LOG.info("SQL Query : " + result.getSQLQuery());
LOG.info("SQL Query Parameter : " + result.getSQLQueryParameters());

// If debug is enabled the equivalent SQL for the Flexible search can be shown in the logs.

if (LOG.isDebugEnabled()) {

FlexibleSearchQuery query = new FlexibleSearchQuery(builder.toString(), params);

TranslationResult result1 = getFlexibleSearchService().translate(query);

LOG.info(" SQL Query : " + result1.getSQLQuery() + "\n");

LOG.info(" SQL Query Parameter : " + result1.getSQLQueryParameters() + "\n");

}