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, which is a prerequisite for using this component. The underlying database engine is SQLite 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

SQL tree console

Preferences dialog
Edit column dialog
Custom SQL functions
MetaDb_Module

Advanced options