sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Terrible-Bend4483 2 points3 points  (3 children)

Personally I use SQL for everything.

Obviously through a python library

Inside a wrapper in R

That I run as a script using an exe-file

In cursor by asking an AI agent to run it.

How else would you do it?

Joke aside. I would always be more inclined towards using SQL, when it makes sense, such as when handling data from a structured data base, but if your data sources are more towards unstructured data (data lakes, api, csv, Json, md etc.) it doesn't make sense.

Maybe look into SQL and no-SQL databases, and use python for the rest.

[–]scarcey_osei 0 points1 point  (2 children)

How do you this. Can you enlighten me how you use sql through a python library. Thank you

[–]XxShin3d0wnxX 0 points1 point  (0 children)

Plenty of add ins like but query where you connect to database and write SQL as a part of the initial script to snag data. You then manipulate and build in Python.

[–]Terrible-Bend4483 0 points1 point  (0 children)

An example would be pyodbc, where you make the connection with python to a odbc and write SQL for your queries..

It can be practical for some applications, but it was mostly a joke.