Remaining WP Core Tickets (including two new ones) as follows:

Filtering get_meta_sql for advanced queries – http://core.trac.wordpress.org/ticket/15018
Filtering get_search_sql for advanced queries – http://core.trac.wordpress.org/ticket/15249
Filtering get_tax_sql for advanced queries – http://core.trac.wordpress.org/ticket/15250