Netsuite ODBC filter not folding

Yep, nothing too complicated. We created an postgres database on azure, and then used stitch as a service to propagate the data. Stitch's limits mean it can be a little expensive for a medium size company, but we found it works well for the majority of data that can be replicated by timestamp+Id. For the data that isn't keyed and so can't be efficiently replicated we use a logic app with some azure functions for specific scenarios, but naturally that leads to complication so we try and keep it to a minimum.

Once you're using the postgres connector, or probably sql server or any of they other mainstream rdbms, the folding works great.