Query external database and show dynamic response

Hi there,

I’m wondering if it possible to use WP with Formidable Pro as a web search system. I want only logged-in users can edit the query form and send it. SQL statement is generated from the user input and query to my database runs. A dynamic page is generated as a response containing the user input (specified  query condition) followed by the query result . If the user is content with the result he/she can save the form as a private page in WP for later reference if not the page is discarded on leave. There is no needs for an administrator to be notified by email or by any means on form submission.

Thanks in advance.

Yochi