# Custom sql queries beyond CRUD

**URL:** <https://www.ruby-forum.com/t/custom-sql-queries-beyond-crud/75653>\
**Category:** Rails\
**Created:** [March 2, 2006, 10:32am UTC](https://www.ruby-forum.com/t/custom-sql-queries-beyond-crud/75653 "2006-03-02T10:32:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tuka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7c8e57/32.png) [@tuka](https://www.ruby-forum.com/u/tuka)\
**Post date:** [March 2, 2006, 10:32am UTC](https://www.ruby-forum.com/t/custom-sql-queries-beyond-crud/75653/1 "2006-03-02T10:32:50Z")

</div>

Hi,

I am just starting of in rails. I am trying to understand the features  
of rails and I have this burning question. (and search is not available  
now):

Apart from relying on the automatic CRUD sql script produced, is there a  
way I can create my own sql script ex: with many joins between exixting  
tables (for reporting ). All I need is to declare the custom query and  
place the result in a recordset and then to display it somewhere.

Thanks also for any links to documentation that clarifies this.

TIA,  
Tuka

PS: I dont program with ruby yet… but I can easily read any snippet  
given… I think

---

<div class="post-metadata">

**Author:** ![tuka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7c8e57/32.png) [@tuka](https://www.ruby-forum.com/u/tuka)\
**Post date:** [March 8, 2006, 9:40pm UTC](https://www.ruby-forum.com/t/custom-sql-queries-beyond-crud/75653/2 "2006-03-08T21:40:22Z")

</div>

Thanks a lot, this helps  
Cheers  
tuka

---

<div class="post-metadata">

**Author:** ![tuka](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7c8e57/32.png) [@tuka](https://www.ruby-forum.com/u/tuka)\
**Post date:** [March 5, 2006, 6:49am UTC](https://www.ruby-forum.com/t/custom-sql-queries-beyond-crud/75653/3 "2006-03-05T06:49:34Z")

</div>

On 3/2/06, Tuka O. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Thanks also for any links to documentation that clarifies this.

You can use the “direct” database selectors if you need them:  
[http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M000532](http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M000532)  
They are particularly useful for accessing DB-specific features that  
you can’t get at through the normal connection adapters, or for  
connecting to horrible legacy stored procedures.

Edge Rails also includes some very handy calculation features for  
complex sum/partition statements.