I believe you can use the full version of oracle for ‘development’ w/o incurring a license cost, but I would confirm w/ oracle on their terms.
Otherwise we don’t support anything other than MSSQL and Oracle. Postgre at one point had a plugin or something that was supposed to make it a drop in replacement for oracle so you could try that.
I don’t know of any crippling due to use XE, other than being limited to 5g of tablespace. That limitation means you can’t do a default install of bdssa.