i am developing a module for prestashop, this module create a table in the database during its installation.
But I read a long time ago, that some hosters especially turnkey, can block access to the database (make a CREATE TABLE) to the modules.
I do not find info on the net, someone would have info.
If hosting allows to install Prestashop it makes no sense that it blocks table creation. You can try a module test generated by PS creator (https://validator.prestashop.com/generator) and watch if table is properly created.
I am PS developer and work with several hostings and never had problems.
Modules installation is a common task, it is strange to have not create table permission.