Is there any standard way to form a long list with some columns into a wide table where the pivot head lines (beside the grouping columns) are taken from the long list and the fields are calculated or also taken from another field of the long list?

I know that there exists somewhere a virtual table mechanism but is this the only way to achieve this from SQLite3 and everyone who is interested has to do the implementation again and again on its own?

I found some example for PostgreSQL crosstab and the function crosstab on their site.

Is there any planning for such functionality native by SQLite3 ?