So this covers some of the same ground as JDBC, but also some extra
Since JDBC is one of the types, it covers all of it.
Does this mean the queries to MariaDB using CONNECT are identical to
ordinary native SQL queries?
Yes, exactly. So we could have two approaches to Cassandra: native Cassandra QL, which has one set of strengths, or SQL via Maria, which has another set.