foo_uie_sql_tree

foo_uie_sql_tree is a foobar2000 component for viewing the media library in a tree structure using SQL queries. The component provides a panel for ColumnsUI or DefaultUI, which is a prerequisite for using this component.

The underlying database engine is SQLite provided by foo_sqlite, which is also a prerequisite for using this component, and with the exception of a few restrictions for building the tree queries the whole functionality of SQLite is supported. More details can be found here.

Overview

SQL tree panel
SQL tree options
Select icon dialog
Folder node dialog
Query node dialog - Main
Query node dialog - Query
Query node dialog - Action
Query node dialog - Batch
Query node dialog - Advanced
Query result node dialog

Advanced options