Specifically:

Upgrade to 333:
CANT CREATE PK ON A NULLABLE COLUMN
function upgrade333($oDB)
{
$oDB->createCommand()->createTable('{{map_tutorial_users}}', array(
'tid' => 'int NOT NULL',
'uid' => 'int DEFAULT NULL',
'taken' => 'int DEFAULT 1',
));

$oDB->createCommand()->addPrimaryKey('{{map_tutorial_users_pk}}', '{{map_tutorial_users}}', ['uid', 'tid']);

Upgrade to 338:
CANT INSERT INTO IDENTITY COLUMN - Postgres 'fix' below has broken SQL Server
// NB: Needed since Postgres id seq might not work.
$maxId = $oDB->createCommand()->select('max(id)')->from("{{boxes}}")->queryScalar();

        $oDB->createCommand()->insert(
            "{{boxes}}",
            [
                'id' => $maxId + 1,
                'position' => $position,
                'url' => 'admin/themeoptions',
                'title' => 'Themes',
                'ico' => 'templates',
                'desc' => 'Themes',
                'page' => 'welcome',
                'usergroup' => '-2'
            ]
        );