Programming

568 readers

1 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

[email protected]

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

submitted 1 year ago by [email protected] to c/[email protected]

3 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

[–] [email protected] 1 points 1 year ago* (last edited 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