GitHub user thadguidry edited a comment on the discussion: How to get data from a database with a constructed query?
We'll, I can retype it here and give some more background also: A great way to handle this is to use additional technology like [DB2Rest](https://db2rest.com), as an example, to automatically create an API endpoint for your database and then work with the URL parameters. I can attest that it’s already being used by large companies to migrate legacy databases and enable fast frontend development. The bonus is that it mitigates SQL Injections because it uses prepared statements as well as becomes an automatic API gateway for your database. Of course, there are other "automatic API" type middleware, but we found they were hard to use, and not performant, or lacking features, so we built DB2Rest to make it simple for DBA's and frontend engineers, both. https://db2rest.com GitHub link: https://github.com/apache/hop/discussions/4566#discussioncomment-11264469 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
