Hacker News Reader

Comment by nerdponx | Hacker News Reader

I much prefer writing actual functions in a real programming language to the verbose non-reusable non-composable relic that is SQL syntax.

Give me a better query language and I will gladly drop Pandas and Data.Table.

View on HN

Yes, SQL does have the problem of bad composeability and some things being less explicit than they are when working with dataframes. Dplyr is probably the most sane API out of all of them.

+1 for dplyr. I've used both pandas and dplyr daily for a couple years at different times in my career, and there is no comparison in mind when it comes to usability/verbosity/number of times I need to look at the documentation.

I agree, the degree of expressiveness that dplyr achieves is impressive. The library has had a great impact on my work. The syntax is easy to remember so you don't have to constantly look up minor variations in usage. Also, the pipelining aspect makes it dead-simple to debug. It's especially powerful when combined with the purrr library: https://purrr.tidyverse.org/

SQL is a real programming language.

It's not turing complete which is I think why it doesn't feel like a "real" programming language.

Recursive CTEs exist; while I haven't investigated thoroughly, I would be surprised if they didn't make SQL turing complete.

More usefully, most databases allow you to write user-defined functions in other languages, including imperative SQL dialects.

SQL is turing complete. A demonstration with recursive CTEs is done here[1].

[1]: https://wiki.postgresql.org/wiki/Cyclic_Tag_System

Oh wow. I stand corrected. Thanks!

Reply on news.ycombinator.com