i'm new to osquery, but when i first did a little poc this worked straightforwardly for e.g.

select * from users