Can Drop Tables display lists of joomla users that include a column for every core custom field?

I see that Drop Tables can be used to display data from a joomla database table. Is it possible to display a table that shows all the Joomla Users that includes a column for their name and every core custom field that has a value? I've tried to do this using an sql query but it takes a lot of Table Joins to do it. I'd like to create pages that display lists of Joomla users meeting certain criteria, selected columns from the core fields, and make this clickable so as to show the users complete profile. I read the tutorial on your site. It does seem like it would still require some creative table grouping. Thanks!