Join syntax in request body.

[kdhrubo]

Here is the set of tables to help design the syntax for no FK and implicit joins.

[kdhrubo]

@thadguidry @musibs @rajivmca2004 @souravroy @susanta-mukhopadhyay - pls feel free to share your feedback.

[kdhrubo]

Single Table Join 1

select 
          om.order_id as orderId, 
         om.order_date as orderDate, 
         od.line_number, 
        od.description, 
        od.quantity
 from 
        OrderMaster om 
join OrderDetail od on om.order_id = od.order_id

POST

/OrderMaster?fields=order_id:orderId,order_date:orderDate

[

{
    "table" : "OrderDetail",
    "filter": "order_id=eq=order_id" 
}

]

filter: specified as RSQL
type : not specified use default 'INNER'

[kdhrubo]

Join syntax implemented hence closing this discussion.