How to convert SQL select queries to korzh easy query data model and export to XML

154 Views Asked by At

Previously I was using KORZH Easy Query Data Model builder for AD-Hoc reporting. I was using Data Model Editor tool for that manually. Now I am using dev express query builder to generate queries but my previous AD-Hoc reporting requires XML based queries generated using Data Model Editor tool. How can I generate XML like data model editor. Is any way to convert SQL query to KORZH easy query data model XML.

1

There are 1 best solutions below

1
Brian Freeman On

I would recommend going from SQL to Abstract Syntax Tree (AST) first. Then AST to EasyQuery XML.

Its not an easy problem. I would move back to EasyQuery or change 100% to something that works with dev express.

Sql Parser from Microsoft