Customize a 3rd party EDI transformer to convert from my SQL into X12 EDI 835/837 formats

I have an SQL database which I will be loading with data from Invoices, CMS-1500, CMS-1450, and EOB data. I need an automated tool that will take the data from SQL and convert it to X12 EDI. Preferably, you will recommend and use some 3rd party EDI translation tool of your choice (which you have experience with) instead of writing a custom conversion code. I will purchase this tool license if it is not free. Your responsibility will be to setup SQL table per document type (CMS-1500, EOB, Invoice, etc.) with meaningful field names. I will load that table fields with my data. You then need to create a mechanism that will convert this data to EDI output automatically. Initial project requires 3 document types: CMS-1500 (EDI 837), CMS-1450 (EDI 835), Purchase Order (EDI 850). Later I will request more formats as a new project. In your response, make sure to include: a) your experience with x12 EDI b) what 3rd party tools and costs you plan to use c) brief explanation of architecture I am a developer and technical software consultant myself. Please feel free to ask me any questions.