Can you give some examples for "repeatedly tried to kill SQL"?
For me it's only KeyValue/NoSQL (which trades/focuses on some ACID traits over others) and various incarnations of ORMs (which try to normalize different SQLs and map it to your familiar OOP programming language) that come to mind.
However they are either orthogonal or complementary to SQL.