why aren't all 20 resolved? a statement only gets an assessment when the public
record can support or contradict it. opinions and what-ifs never can, and 0 checkable
ones are still open, waiting for their date. predictions held up or didn't;
assertions are supported or contradicted. on every card:
▮▮▮▮▮ certainty ·
▮▮▮▮▮ debate potential. speakers are clickable
Opinion
Stancil: dbt's SQL-based semantic layer is not a real semantic model
“They're moving in, like, the semantic layer tool, so basically they're saying, give us raw data, and we will tell you, like, apply semantics to it. The way that they do that now is through SQL. So, like, semantics are kind of, like, air quote semantics. It's b…”
Opinion
Mike Palmer: Forcing SQL concepts into natural language is engineering hubris
“So the idea that I'm supposed to adopt a SQL semantic concept into my natural language is the ultimate hubris of engineering.”
Prediction Not checkable as stated
Rogojan: SQL will remain essential as LLM raw data-dumping approaches fail
“The next one I said SQL isn't going anywhere, and I kind of said that for more than one reason. One, I feel like someone's going to tell us it's time to revamp data lake v one again, where we'll just dump everything in there and we'll let an LLM figure it out …”
Prediction Not checkable as stated
Handy: Data processing will be polyglot with non-SQL abstractions within five years
“We really do think that the future of data processing is polyglot, and I think that if you look in five years, you will find more robust abstractions on top of data, and even in the DBT ecosystem, than SQL.”
Insight
Narayan: Software requiring code rewrites in new languages is largely doomed
“Any pitch. I'm generally very skeptical where you can tell folks, you can have all these great new benefits of low latency or whatever it is, but you got to start all over from scratch, right? You have to throw everything out there and you're going to rebuild …”
Insight
Elsamadisi: Time and customer identity replace foreign keys when relating multi-system data
“Instead of depending on foreign keys to relate the data, you can actually just use time and customer.”
Insight
Stancil: Knowing SQL and charts doesn't make someone a data analyst
“Me knowing SQL and me knowing how to create a chart doesn't make me an analyst any more than knowing Photoshop makes me a designer.”
Insight
Rogojan: Understanding data flow takes longer than learning SQL syntax
“SQL you can learn quickly. What's going to take time is just getting a sense for how data Operates and flows and data sets in general.”
Assertion Contradicted
VAST Data enables native SQL querying directly on Parquet objects
“You can write a parquet object and then query it using SQL natively off of our platform without needing any higher layers on top.”
Insight
Standard SQL queries are virtually impossible for complex location data analysis
“Trying to put together SQL queries in such a manner to understand those interrelationships is virtually impossible, and honestly was part of the reason that you don't see a lot of the value derived when you buy the data, because you have to spend so much time,…”
Assertion Not checkable as stated
Argyros: Most enterprises handle CX data operations using analyst teams writing SQL
“The way this problem is solved in most enterprises is that you deploy armies of analysts, and they get tickets and requests, and they write SQL, right?”
Assertion Not checkable as stated
Handy: 100x more people write SQL than Spark or Scala
“There are actually two orders of magnitude more human beings on the planet that can write SQL than can write Spark or Scala or whatever.”
Assertion Not checkable as stated
Handy: Data transformation has shifted inside data warehouses using SQL
“What's happening now or over the past, you know, five or so years, the, Transformation step now happens inside the data warehouse and it happens in SQL. And because of that, it is now accessible to a dramatically larger number of people.”
Insight
Stancil: Technical data skills are learnable, analytical thinking is harder to teach
“They're gonna need SQL skills, they're gonna, they might need Python or R skills, they'll need something like Excel but those things are learnable, whereas I think, like, the way of thinking is often harder to teach.”
Assertion Partly supported
CockroachDB combines NoSQL elastic scalability with SQL strong consistency
“So, you know, Cockroach bridges the gap. It's both of those things. It has both of those things, and it doesn't compromise.”
Assertion Not checkable as stated
Birchbox trained nearly its entire company workforce to write SQL
“Trained almost the entire company to use SQL.”
Insight
Deighton: Key data insights often lie outside chosen query selections
“Oftentimes, ah, from a question perspective, the interesting insights in the data are actually found outside of your selection, ah, outside of your query.”
Opinion
Gong: The data ecosystem critically needs a SQL linter like SQLFluff
“The other one that I, I'd point to that I haven't used deeply myself, but I just think is a thing that the world really needs is SQL fluff. SQL FL U F F. And it's a linter for SQL. And I'm just kind of shocked that we have got to 20 21 without there being a, l…”
Disclosure
Kimball in 2015: CockroachDB SQL support is aspirational and not started
“The top, the very top, SQL, is aspirational. We do intend to do it but we haven't started working on it yet.”
Disclosure
Wiggins: NYT data science stack relies on SQL, scikit-learn, and Go
“So the data stack is, in my team, the data stack is SQL and scikit, and occasionally Go”