All questions that link to pivot refer to the pivot functionality within google-sheets-query. I've submitted usage guidance to it which will hopefully get approved.
Due to (currently) having no usage guidance, it causes users to accidentally confuse it with pivot-table, which is unrelated.
Even if usage guidance gets added, it will be much clearer to just call it directly what it means: google-sheets-query-pivot or at least query-pivot.