I am new to Joomla development, coming from Magento. Working through the tutorials with a certain extension in mind I stumbled upon a little problem.
By now Joomla supports MySql and MSSQL and more might come.
From Magento I am used to build Extensions with Database agnostic install scripts, since I have no influence on which database the end user will run.
In the Joomla tutorials I only get told to use raw sql to create tables and stuff, but there are some distinction in Syntax between MySQL and MSSQL and maybe even more differences to other sql implementations which joomly might support soon.
In my php files I can simply use the Database adapters Joomla provides in order to keep things abstract, is there a way to use .php files as install scripts instead of .sql files? Or is there another way to create install scripts which work with any database? Or is joomla actually interpreting the MySQL syntax of the .sql files itself?
Thanks for any help.