Do you plan any changes in MVC where you forward table name to lastInsertId function? Currently when you dont use sequence tables the sequenceName param is null which is described on https://github.com/phalcon/cphalcon/blob/bf9da26e6e20ea05dd69881b9cd0c2536ec53bcb/ext/mvc/model.c#L3596. It would be really great assign table value to sequence_name variable because latest version of MSSQL returns null for SCOPE_IDENTITY query and only function which certainly works needs tableName or is there any different way how I can read table name from adapter?
Edit 1: It almost looks like Phalcon close connection to DB immediately after query or something like that because I get null when I insert new value. However when I test same insert query in SQL Management Studio, everything works well.