It looks like you're new here. If you want to get involved, click one of these buttons!
I definitely like where_search.
Would it be possible to extend the search to the columns extracted using subquery?
Like author_name in the following example:
$items = books\Book::query("id, title, author, (select name from authors where authors.id = books.author) as author_name")
A solution could also be to create a model of a sql view (ie. only for select). Is that possible?