They're sort of different categories.

Tools like Q are for command line use.

Dremio is a server/web application, right?

They accomplish the same thing but you might deploy a tool like Q on production servers for adhoc log analysis or install it in a docker container. (Not saying you should, just explaining the difference.)