Using Zend_Paginator without Select Adapter

[veJaonsure]

I want to use \[code\]Zend_Paginator\[/code\] but \[code\]Zend_Paginator\[/code\] requires \[code\]Zend_Db_Select\[/code\] as input parameter.My SQL query is some how a little complicated making it so difficult to implement with \[code\]Zend_Db_Select\[/code\].Can i use \[code\]Zend_Paginator\[/code\] with plain SQL query?