Odata equivalent to MySQL query or Mapping of SQL query to OData one

[Java Dev]

What is Odata equivalent to following mysql keyword or usage

• distinct
• join/inner join
• left join/left outer join
• right join/right outer join
• full join/full outer join
• like operator
• min/max operator of a column
• rownum or rowcount comparison
• group by
• having count() and exists()

How to use $expand with respect to join or left outer join in mysql?

Is there is any plugin or tool available which does mapping of SQL query to OData one? Or Conversion of MySQL query to Odata

Thanks

[Ralf Handl]

OData's query language is not a direct equivalent of SQL. Some similar operations and query options are:

* distinct: see <http://docs.oasis-open.org/odata/odata-data-aggregation-ext/v4.0/cs02/odata-data-aggregation-ext-v4.0-cs02.html#_Toc435016609

* join: no direct equivalent, instead OData uses navigation properties for related information

* like: startswith, endswith, contains, see https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part2-url-conventions.html#sec_StringandCollectionFunctions

* min/max/sum/count: http://docs.oasis-open.org/odata/odata-data-aggregation-ext/v4.0/cs02/odata-data-aggregation-ext-v4.0-cs02.html#_Toc435016571

* groupby: http://docs.oasis-open.org/odata/odata-data-aggregation-ext/v4.0/cs02/odata-data-aggregation-ext-v4.0-cs02.html#_Toc435016582

Kind regards

Ralf