It's only a slight misstatement; scalar queries are a subset of table queries in SQL, rather than different thing, but scalar queries are allowed in places where other table queries are not.
The difference in EdgeDB isn't really everything returns a set, but seems instead to be that everything consumes sets and not just scalars.