What, whatever is demoed by Neo4J in their playground is awesome, I used it for just a couple of days but could pull up convoluted queries off DBPedia (producers who worked with artists who were born in countries who have orange in their flag, things like that).
The basic uses of SQL are indeed easy to learn, but quickly you find out that many types of nested queries are no-nos.