Hey,
I think you can do it by just removing the 'AS' and just inserting the name you want after the entity.
Best,
Miguel Sabugueiro
Use the OQL-function Cast, like this:
admin.userdetail.name AS District,
admin.userdetail.name AS Zone,
CAST ('2022-10-05' AS DateTime) AS duedate
FROM admin.userdetail