Here are a couple of queries I'm using, for anyone else that might find them useful...
Artist / Release
SELECT
coalesce([album artist],artist,'.Unknown Artist') album_artist
,ifnull(substr(date,1,4),'Undated')
||' – '||ifnull(album,'Untitled') release
FROM MediaLibrary
ORDER BY
coalesce([album artist],artist,'.Unknown Artist') COLLATE NaturalNoCase
,ifnull(substr(date,1,4),'Undated')
||' – '||ifnull(album,'Untitled') COLLATE NaturalNoCase desc
,discnumber,tracknumber
Style / Artist / Release
SELECT
coalesce([style],genre,'~Unknown Style') genrestyle
,coalesce([album artist],artist,'Unknown Artist') album_artist
,ifnull(substr(date,1,4),'Undated')
||' – '||ifnull(album,'Untitled') release
FROM MediaLibrary
ORDER BY
coalesce([style],genre,'~Unknown Style')
,coalesce([album artist],artist,'Unknown Artist') COLLATE NaturalNoCase
,ifnull(substr(date,1,4),'Undated')
||' – '||ifnull(album,'Untitled') COLLATE NaturalNoCase desc
,discnumber,tracknumber
Year / Artist / Release
SELECT
ifnull(substr(date,1,4),'.Undated') date_col
,coalesce([album artist],artist,'Unknown Artist') album_artist
,ifnull(substr(date,1,4),'.Undated')
||' – '||ifnull(album,'Untitled') release
FROM MediaLibrary
ORDER BY
ifnull(substr(date,1,4),'.Undated') desc
,coalesce([album artist],artist,'Unknown Artist') COLLATE NaturalNoCase
,ifnull(substr(date,1,4),'.Undated')
||' – '||ifnull(album,'Untitled') COLLATE NaturalNoCase desc
,discnumber,tracknumber