I have a custom function on oracle database called create_identifier. It acccept a string and a column and concatenate the abbreviated form of the string to the column.

I am trying to get the python sqlalchemy orm equivalent of

select(select create_identifer("Name", u.name) from dual), u.id from User u

I am not sure how to get the oracle default table in python sqlalchemy orm.

I tried

select(select(func.create_identifier("Name", User.name) from dual), User.id) from User 

I also tried the SQLCompiler.default_from, it is not working I guess it is more compatible with raw sql than orm.