Foreman is essentially a Ruby on Rails application. A big one. And Ruby on Rails applications usually support multiple relational databases thanks to ActiveRecord stack. That’s also the case for Foreman. But it’s not that easy.
This is a companion discussion topic for the original entry at https://theforeman.org/2019/09/dropping-support-for-mysql.html