ArcGIS Pro 3.1.1; mobile geodatabase
Catalog —> Properties —> Definition:
This is what a database view SQL definition looks like for various DB/GDB types:
File geodatabase view:

select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table
Oracle 18c database (non-GDB) view:

select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table
Mobile geodatabase view:

CREATE VIEW TEST_TABLE_NT_FLAG_VW AS select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table
Question:
Why does the mobile GDB view contain CREATE VIEW TEST_TABLE_NT_FLAG_VW AS , whereas FGDB and Oracle views do not?
If I look at the mobile GDB view in a SQL client like DBeaver, I don't see CREATE VIEW TEST_TABLE_NT_FLAG_VW AS in the view definition. I only see it in ArcGIS Pro.
