[sourcd]

It's not every day that you come across such rave comments about a "Show HN" kind of thing. Congratulations to the dev.

I'm not familiar with enterprise / Excel requirements & use cases. Could someone explain why is this such a great product [1]. I wrongly assumed that excel champs won't be comfortable dealing with SQL because they are either non-engineers or have been away from programming for way too long.

[1] No offense to the author, I'd love to understand what the enthusiasm is all about.

[tryitnow]

Excel superuser here. There's a lot of excel users who aren't comfortable with SQL, but I think they're a dying breed. The SQL you need to know for about 99% of your workflow is something you can learn in a couple of weekends. Most of the younger people I know learn SQL basics in college (I'm talking about business people, not just engineers).

Spreadsheets are just really terrible at data manipulation. Good Excel analysts know this and understand why a query language is so useful.

Data usage is exploding and business users want to roll their own analyses and not wait around for an IT ticket to be filled. So having business users able to easily use SQL in Excel makes things a lot more efficient.

Using VLOOKUP functions and pivot tables is just not an elegant solution to a lot of data problems. A SQL script would be much more useful.

[tuyguntn]

Have similar thoughts and would like to know others opinion on that.