Create the shell of an Odata handler for nikita
Created by: tsodring
We need to start to handle odata queries and there is little ability to do this in our technology stack. So we have to come up with a solution. There are a number of approaches we can take.
-
Using elastic search, we could build an approach as described here
-
Create a odata query parser and convert to sql/hql
-
Create a odata query parser and convert to simple-query-string
-
Is a sensible approach, but is going to bypass the jpa layer so it does not make sense given our stack. Both 2. and 3. are based on a similar approach, but require our own OData parser, which is probably going to difficult. The following code has done something similar converting odata to sql with mssql, so we could perhaps do the same for hql. The point is that writing an entire odata2sql library is going to be a large undertaking. But perhaps we just have to bite the bullet and do it ...