A while ago, I heard how good RethinkDB is and tried to check it out and found this page. https://rethinkdb.com/docs/sql-to-reql/javascript/ The more complex the query becomes I just felt everything was getting less intuitive compared to the SQL version and ended up not actually using it. For anyone who switched from SQL, I'd like to know how it felt to write RethinkDB queries. Did they start to feel fluent later on?
I haven't used RethinkDB in ages, but when I did, I used it exclusively for a year. It took a few weeks for ReQL to really sink in, but once it did, I much preferred it to SQL. As my sibling comment says, its very linear: do this then this then this then this. It also feels very much like sequence processing in functional languages (and I was using Clojure at the time, so it really meshed very well). I also found it…
With ReQL you new exactly how indexes were being used, and how the data was being accessed. No trying to guess what the query optimizer was doing in the background.