I simply add (trans) to that persons name in the Authors column.
Calibre will keep these separate, even if the Translator is also a Author
(illus), (ed) are other flags.
The advantages:
1) the reader supports Author entries
2 No special columns
3) Calibre ignores stuff inside ( ), when computing Author_sort