Is there an option to add a column alias to the table definition

Hi Ankit,

In a general way, I see flex table more like a staging table. For any reporting you should move data to regular table with ROS storage, it would be much faster. It's true that it comes with some data engineering but you can't win the race if you don't tweak the car.

For your question, you can create either a column with a DEFAULT / SET USING condition that map to any expression, or use a view to achieve the same purpose.

Additionally, you can execute:
ALTER USER YourConsumingApplicationUserName SEARCH_PATH YourViewSchemaName, public;
This ensures that the user will use the same table name but refer to a view because it will be the first schema it looks for.

Additionally, if the consuming application run specific similar queries, consider using directed queries which can replace the original query with the one which use the UpToDate column names.