Data type conversion to e-mail fails

Data type conversion to e-mail fails

I have a regular table with a column data type:email, and a custom formula where I basically make an email from another column clickable and add a subject line with this formula:

concat( "user_email",'?subject=Custom Subject Text')

This works fine in the table view. When I click the link it opens a new message in outlook with the email and subject filled out.

However when I clean up the table a little by creating a Query table, this column is converted into the data type 'Plain text'. If I go to change data type and try to make it into type: e-mail, I get the following error message:

Data type conversion aborted since the existing data in the column Email is not compatible to the data type E-Mail.

So currently the email links are not clickable in my Query table although they are in my original table. How can I remedy this so it works the same as in my regular table?

Thanks!