BuddyPress.org

It’s all down to what the query needs to do. If it needs to return every field from the records in a table, you may as well use a star, but if you only needed a particular column or two (or three, etc), then you just query for those specific columns.