I am curious about how this compares to dataview. As a dataview user, I'm not immediately seeing something bases does that dataview doesn't, but I am not a power user.

Dataview can be used for queries that output tables, but its strength is letting you write essentially custom imperative Javascript code that renders stuff in notes dynamically (dataviewjs mode). Whereas "queries to tables" is more or less what Bases does, the dataviewjs mode will probably always be unique.