At the moment, when creating a smart playlist, there is only one field that can be sorted on within the "Sorting" UI panel. So for instance, if a smart playlist is sorted on "Sort Songs By", only one field can be specified. This makes it impossible to sort, for example, recently added tracks by date created, and then sub-sort those by the track number of the album, so that you can listen to an recently added album in the order of album tracks. Or sort albums in year added, and then sort by duration, or album order, etc. Since sqlite3 has the ability to specify multiple ORDER BY sort fields when doing a SELECT, in principle, the change is mostly a UI update to add the ability to add multiple sort fields, instead of just one.

At the moment, when creating a smart playlist, there is only one field that can be sorted on within the "Sorting" UI panel. So for instance, if a smart playlist is sorted on "Sort Songs By", only one field can be specified. This makes it impossible to sort, for example, recently added tracks by date created, and then sub-sort those by the track number of the album, so that you can listen to an recently added album in the order of album tracks. Or sort albums in year added, and then sort by duration, or album order, etc. Since sqlite3 has the ability to specify multiple ORDER BY sort fields when doing a SELECT, in principle, the change is mostly a UI update to add the ability to add multiple sort fields, instead of just one.