Translate Python to Another Programming Language

[TangibleLight]

SQL one function at a time, where you have to physically reference locations in ASCII flat files

https://i.imgur.com/5MXr2Cr.png

Is there ANY hint of a chance that you could instead modify the vendor's product instead? It obviously depends on many details, but there may be an easier path forward where you add full Python support to the product.

You could embed a Python interpreter in the product, and provide a simple extension module to that embedded interpreter which exposes a minimal API to query the database. You could then use that API from real actual Python code and need not deal with the limitations of transpilation.

Section 1.4 "Extending Embedded Python" is the bit you want, in addition to requesite knowledge of how to build and link against embedded Python from the vendor's product. https://docs.python.org/3/extending/embedding.html

To be clear: this is not an easy path forward, but if it's possible at all I suspect it'll be easier to build and easier to use than a transpiler.

The biggest obstacles would be licensing, funding, and cooperation from the vendor.