I always wish I wouldn’t have to pull in python/pandas to do simple data transformations on smaller local datasets/csv files and stick with sqlite. But then I tend to quickly hit a problem that seems to require dynamic SQL. Anything in between SQL and a general programming language that is made for transforming tabular data?
You must log in or register to comment.
Maybe R with RStudio? I always found RStudio really nice for handling data despite not really liking R.
tsql and plsql allow more flexibility than plain sql and are integrated in most modern platforms like postgre
typical enterprise tool would be informatica
