Using a sql alias within a model's find() function

You can also use this library, although it uses slightly different table layout: https://github.com/michalsn/codeigniter-translatable

michalsn.dev - mostly about CodeIgniter