Handy DQL: List all groups for a user

The following DQL lists all groups that a user belongs to directly or indirectly:

select * from dm_group
where any i_all_users_names = 'UserName'

Replace UserName with the actual user name under consideration.