rails ajax sql requests

I'm trying to dynamically load SQL results into a table with the ability to narrow search, click categories and through ajax, change the results.

Any documentation or tutorials on this -- or words of wisdo开发者_如何学Cm on getting this started?

You can start with this railscast on rolling your own. Then you can check out the sortable_table plugin/gem and just use that. You'll have to add your own filter row, but that's pretty easy, it's just a simple form.