Programming

13368 readers

2 users here now

All things programming and coding related. Subcommunity of Technology.

This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 1 year ago

MODERATORS

alyaza@beehaw.org

Hexorg@beehaw.org

remington@beehaw.org

Is SQL a good language for data transformations? (discuss.tchncs.de)

submitted 1 year ago by Mattol@discuss.tchncs.de to c/programming@beehaw.org

4 comments fedilink hide all child comments

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 are viewing a single comment's thread
view the rest of the comments

[–] Gaywallet@beehaw.org 3 points 1 year ago

tsql and plsql allow more flexibility than plain sql and are integrated in most modern platforms like postgre

typical enterprise tool would be informatica