A dear friend of mine recently introduced me to the word “queerplatonic.” Most simply put, queerplatonic refers to the deep, intimate, emotional connections sans a sexual relationship. It’s more than friendship, and different from a sexual, and sometimes romantic, relationship. The word zucchini is used to describe someone one’s queerplatonic, committed (perhaps life) partner. You can read about its meaning and subtleties at these links:
Definition
FAQ
And, from the fyeah blog: