How can I create custom queries in ActiveRecord?

How can I create custom queries in ActiveRecord?

You can create custom queries in ActiveRecord by using the where method, scopes, or even raw SQL queries.

Can you give me an example of using a scope for a custom query?

Sure! You can define a scope in your model like this: scope :active, -> { where(active: true) }. Then you can call ModelName.active to get all active records.

What if I need to combine multiple conditions in my query?

You can chain multiple where clauses together. For example: ModelName.where(active: true).where('created_at > ?', 1.year.ago).

Is it possible to use raw SQL in ActiveRecord queries?

Yes, you can use the find_by_sql method for raw SQL queries. Just be cautious with SQL injection!