I have some confusion about query writing in CodeIgniter.

Should I write a query in the model or controller?

I want to know the international standard of query writing in CodeIgniter.

What would be best practice?