Yes, you may define database scripts in your file based module. See the dbscripts directory in the documentation linked below. Generally, you would define parallel scrips for both MicroSoft SQL and Postgres but this is not strictly required if your module will only be used on your system.

https://www.labkey.org/wiki/home/Documentation/page.view?name=moduleDirectoryStructures

Greg