Reply To: "top … order by" Syntax for smart playlists

#10932
mpoly
Participant

There are lots of requests on playlists, many of which are quite hard to implement because they require Ron to expand and parse more complicated expressions.

Here’s an idea: Allow smart playlist expressions in the format:

SQL:

Where sqlstatement is any SQL that returns a list of Ids from the database. This could be an expert-only feature, with disclaimers:

    This is not officially supported
    There is no syntax checking
    Portability and compatibility with future versions is not guaranteed
    If you accidentally type in DROP TABLE, its your problem.

For those who know basic SQL (and those who know how to ask questions nicely in the forums), this will open many new possibilities.

?