SUMMARY
***
I wish there's an input slot to let user directly write SQL statment (or critiera) to search photos in the Advanced Search pop up(or maybe another "super advanced" pop up). 
Even better, on any display which listing the photos(left tabs, left tabs combined with right tabs, Advanced Serach result, etc.), user can check current SQL critiera so that when he/she writes his/her own SQL for advanced search, he/she can copy & enhance the condition or reference the column/value from the existings.

I understand you've already provided the very powerful "Advanced Search" function. However, there're two issues:
1, after extending a condition category, too much space is occupied. Sometimes I just need one field from one category, but the screen is then full of other useless fields so it's hard for me to get an overview of all the conditions I set, I have to scroll up up up and down down down a lot, this is not friendly to use
2, there's no option for me to "group conditions(Search Groups)". I know I can add multiple conditions, and swithcing AND/OR relationships. But how to group them? A and (B or C), (A and B) or C ? There's no way I can do that. 

Thus, a SQL input will be a great help. 
(If a full SQL statment will cause security issue, how about only the conditions? Or you can warn user like "Using SQL search will at your own risk...."... something like that)
***

STEPS TO REPRODUCE
n/a

OBSERVED RESULT
n/a

EXPECTED RESULT
n/a

SOFTWARE/OS VERSIONS
any OS

ADDITIONAL INFORMATION
(none)