[support] db_query() needing a SelectQueryExtender

[Earnie Boyd]

On Mon, Jun 11, 2012 at 4:04 PM, Earnie Boyd
<earnie at users.sourceforge.net> wrote:
> Ok, I considered db_select because I needed to be able to add an
> extend() method and db_query() doesn't allow for it.  However, my
> query is adjustable by the user with a filter selection that allows
> the user to add OR and/or AND filters on the fly.  The db_or() and
> db_and() methods requires I know the condition()s all at once which I
> don't so now I'm back to use db_query to build the query string as I
> was doing in D6.  However, I need to be able to page the list of items
> such as extend('PagerDefault')->extend('TableSort')->orderByHeader->($header)
> but this doesn't exist in the db_query object.  Is there some means by
> which I can create a SelectQueryExtender object with the db_query
> object as a parameter?  Or does anyone have a different solution?

For others who may need a solution, I decided to use the
SelectQuery::where() API[1] reverting back to db_select().  This
allows me to build the complex where clauses I need and giving the
final string to the object like so, $query->where($where, $args).
This way the extensions are usable.

[1] http://api.drupal.org/api/drupal/includes%21database%21select.inc/function/SelectQuery%3A%3Awhere/7

-- 
Earnie
-- https://sites.google.com/site/earnieboyd