MYSQL as an API Enhance Step

  1. What is your feature/integration request? To include the MY SQL feature as an API Enhance with {column} variables applied in the advanced query function.
  2. What problem would this feature/integration solve?
    I have historical sales data and need to get select information by mysql query for various reports. Instead of importing the entire 300,000 line table, I’d like to grab just the orders from a certain customer, or just the items sold between select dates.
  3. How do you solve/workaround this problem today? Huge imports, if I had the skill I’d create a middleware API using bash, python, php but… that means at least 40 hours of undisturbed time that I don’t have.