Programming

13371 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]

6 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] 2 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

honestly once you're familiar enough with sql you can do whatever you need to do via a series of tables, but most people aren't that skilled

typical enterprise tool would be informatica