I have just published a milestone version of Service Builder in VS Code Marketplace. It is a tool for creating query, command and repository services in a few streamlined steps.

For exampe, to create a query service, you would simply - specify the input and output of the service with plain JSON - write a plain SQL query to return the data set for populating the output, - click a button to generate the input and output bindings (data mappings) as JSON, and then - click another button to add a test to test the service you have just comleted. The service engine takes care of the object-relational transformation. You have the flexibility to go as complex as you need (really?) on the output.

Give a try and let us know how far you go. BTW, just for the purpose of grilling the query engine, you can write a simple query but a complex output to test it out.

It also helps me and probablly to everybody else, if you could share the most complex objects that you have done with ORM or raw SQL in your current or past projects.

Thanks.

Ken