Hello, igniters! To migrate a project to Ignite 2 (using Calcite), I'm missing two pseudo-columns like in Oracle: rowid[1] and rownum[2]. Since it's not an ANSI standard, they're missing, as expected.
But I really need them, as there's some legacy code that I can't change. Any objections to me adding them? If so, why, and what alternatives are there? [1] - https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/ROWID-Pseudocolumn.html [2] - https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/ROWNUM-Pseudocolumn.html
