Things like Amazon Redshift are still relational but make radically different decisions on most of those points.
Edit: that talk is well worth reading, btw. I wonder why he completely ignores flash though?
He's arguing against multithreaded systems in favour of a partitioned OLTP platform like H-Store (VoltDB). I didn't see anything about the relational model being "all wrong". It works well for lots of scenarios, and turning it into a KV store is also straightforward.
As far as SQL, I think people agree it's not the best query language. QUEL may have won, but Stonebraker says[1]: "The only reason SQL won in the marketplace was because IBM released DB2 in 1984 without changing the System R query language."
1: http://iggyfernandez.wordpress.com/2011/12/23/nocoug-journal...
BTW, the person asking the last couple of questions is Ed Bugnion, one of the co-founders of VMWare. He is a faculty now at EPFL.
http://blog.jooq.org/2013/08/24/mit-prof-michael-stonebraker...
htsql seems very interesting. I should soon blog about your product and critique. Have you been publishing elsewhere?