I've been using gremlin for a while with Orientdb , however I noticed that I can get queries answered even faster with Orient SQL.
is it possible to translate the following gremlin script into OSQL:
User --- Likes ---> Item
Find top 15 similar items to item x and filter by item genre property ( assuming item is song) .
item_x = g.v('12:56');
item_x.in('Likes').out('Likes').except([item_x]).has('genre', item.getProperty('genre')).groupCount().cap().orderMap(T.decr)[0..15].map( )
Thank you in advance for you help