Botanically, fruits don’t have to be sweet. It’s anything that’s a seed carrier of some kind. Vegetables are other plant parts that don’t contain seeds, more or less. It. Culinary usage takes a different approach, hence the different aisles.

Not sure about beans, I don’t usually buy canned beans.