simstudioai · icecrasher321 · Sep 11, 2026 · Sep 11, 2026 · Sep 11, 2026
diff --git a/apps/sim/app/api/files/uploads/finalizers.ts b/apps/sim/app/api/files/uploads/finalizers.ts
@@ -1,6 +1,7 @@
 import { AuditAction, AuditResourceType, recordAudit } from '@sim/audit'
 import { type Principal, resolvePrincipalAuditAttribution } from '@sim/auth/principal'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import { type WorkspaceFileRow, workspaceFileColumns, workspaceFiles } from '@sim/db/schema'
 import { generateId } from '@sim/utils/id'
 import { eq, sql } from 'drizzle-orm'
@@ -354,7 +355,7 @@ async function insertOrLoadFileMetadata(
 
   const now = new Date()
   const [inserted] = await db
-    .insert(workspaceFiles)
+    .insert(withInsertColumns(workspaceFiles, workspaceFileColumns))
     .values({
       id: generateId(),
       key: input.key,

diff --git a/apps/sim/app/api/v1/admin/credits/route.ts b/apps/sim/app/api/v1/admin/credits/route.ts
@@ -25,7 +25,8 @@
 
 import { AuditAction, AuditResourceType, recordAudit } from '@sim/audit'
 import { db } from '@sim/db'
-import { organization, subscription, user, userStats } from '@sim/db/schema'
+import { withInsertColumns } from '@sim/db/insert-columns'
+import { organization, subscription, user, userStats, userStatsColumns } from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { generateShortId } from '@sim/utils/id'
 import { normalizeEmail } from '@sim/utils/string'
@@ -155,7 +156,7 @@ export const POST = withRouteHandler(
           .limit(1)
 
         if (!existingStats) {
-          await db.insert(userStats).values({
+          await db.insert(withInsertColumns(userStats, userStatsColumns)).values({
             id: generateShortId(),
             userId: entityId,
           })

diff --git a/apps/sim/app/api/v1/admin/users/[id]/billing/route.ts b/apps/sim/app/api/v1/admin/users/[id]/billing/route.ts
@@ -20,6 +20,7 @@
  */
 
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   member,
   organization,
@@ -247,7 +248,7 @@ export const PATCH = withRouteHandler(
       if (existingStats) {
         await db.update(userStats).set(updateData).where(eq(userStats.userId, userId))
       } else {
-        await db.insert(userStats).values({
+        await db.insert(withInsertColumns(userStats, userStatsColumns)).values({
           id: generateShortId(),
           userId,
           ...updateData,

diff --git a/apps/sim/ee/workspace-forking/lib/copy/copy-files.ts b/apps/sim/ee/workspace-forking/lib/copy/copy-files.ts
@@ -1,4 +1,5 @@
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import { workspaceFileColumns, workspaceFiles } from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { getErrorMessage } from '@sim/utils/errors'
@@ -362,7 +363,7 @@ export async function executeForkFileBlobCopies(
         await db.transaction(async (tx) => {
           assertForkCopyActive(control)
           const [inserted] = await tx
-            .insert(workspaceFiles)
+            .insert(withInsertColumns(workspaceFiles, workspaceFileColumns))
             .values({
               id: task.targetFileId,
               key: task.targetKey,

diff --git a/apps/sim/lib/admin/dashboard.ts b/apps/sim/lib/admin/dashboard.ts
@@ -1,5 +1,6 @@
 import { AuditAction, AuditResourceType, recordAudit } from '@sim/audit'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   member,
   organization,
@@ -11,6 +12,7 @@ import {
   usageLog,
   user,
   userStats,
+  userStatsColumns,
   workspace,
 } from '@sim/db/schema'
 import { generateId } from '@sim/utils/id'
@@ -1524,7 +1526,7 @@ export async function grantDashboardUserBalance(
         ? null
         : getPerUserMinimumLimit(initialSubscription).toString()
     await tx
-      .insert(userStats)
+      .insert(withInsertColumns(userStats, userStatsColumns))
       .values({
         id: generateId(),
         userId,

diff --git a/apps/sim/lib/auth/anonymous.ts b/apps/sim/lib/auth/anonymous.ts
@@ -1,4 +1,5 @@
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import * as schema from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { generateId } from '@sim/utils/id'
@@ -37,7 +38,7 @@ export async function ensureAnonymousUserExists(): Promise<void> {
     })
 
     if (!existingStats) {
-      await db.insert(schema.userStats).values({
+      await db.insert(withInsertColumns(schema.userStats, schema.userStatsColumns)).values({
         id: generateId(),
         userId: ANONYMOUS_USER_ID,
         currentUsageLimit: '10000000000',

diff --git a/apps/sim/lib/billing/core/usage.ts b/apps/sim/lib/billing/core/usage.ts
@@ -1,4 +1,5 @@
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import { member, organization, settings, user, userStats, userStatsColumns } from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { isOrgAdminRole } from '@sim/platform-authz/workspace'
@@ -155,7 +156,7 @@ export async function getOrgUsageLimit(
  */
 export async function handleNewUser(userId: string): Promise<void> {
   try {
-    await db.insert(userStats).values({
+    await db.insert(withInsertColumns(userStats, userStatsColumns)).values({
       id: generateId(),
       userId: userId,
       currentUsageLimit: getFreeTierLimit().toString(),
@@ -182,7 +183,7 @@ export async function handleNewUser(userId: string): Promise<void> {
  */
 export async function ensureUserStatsExists(userId: string): Promise<void> {
   await db
-    .insert(userStats)
+    .insert(withInsertColumns(userStats, userStatsColumns))
     .values({
       id: generateId(),
       userId: userId,

diff --git a/apps/sim/lib/billing/enterprise-provisioning.ts b/apps/sim/lib/billing/enterprise-provisioning.ts
@@ -1,10 +1,12 @@
 import { AuditAction, AuditResourceType, recordAudit, recordAuditOnce } from '@sim/audit'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   invitation,
   invitationWorkspaceGrant,
   member,
   organization,
+  organizationColumns,
   outboxEvent,
   permissions,
   subscription,
@@ -1638,7 +1640,7 @@ export async function issueEnterpriseProvisioning(
 
     if (organizationToCreate) {
       const now = new Date()
-      await tx.insert(organization).values({
+      await tx.insert(withInsertColumns(organization, organizationColumns)).values({
         id: organizationToCreate.id,
         name: organizationToCreate.name,
         slug: slugifyOrganizationName(organizationToCreate.name, organizationToCreate.id),

diff --git a/apps/sim/lib/billing/organization.ts b/apps/sim/lib/billing/organization.ts
@@ -1,5 +1,12 @@
 import { db } from '@sim/db'
-import { member, organization, subscription as subscriptionTable, user } from '@sim/db/schema'
+import { withInsertColumns } from '@sim/db/insert-columns'
+import {
+  member,
+  organization,
+  organizationColumns,
+  subscription as subscriptionTable,
+  user,
+} from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { isOrgAdminRole } from '@sim/platform-authz/workspace'
 import { generateId } from '@sim/utils/id'
@@ -442,7 +449,7 @@ export async function ensureOrganizationForTeamSubscriptionTx(
 
     organizationId = `org_${generateId()}`
     const now = new Date()
-    await tx.insert(organization).values({
+    await tx.insert(withInsertColumns(organization, organizationColumns)).values({
       id: organizationId,
       name: userData.name || `${userData.email || 'User'}'s Team`,
       slug: `${userId}-team-${generateId()}`

diff --git a/apps/sim/lib/billing/organizations/create-organization.ts b/apps/sim/lib/billing/organizations/create-organization.ts
@@ -1,5 +1,6 @@
 import { db } from '@sim/db'
-import { member, organization } from '@sim/db/schema'
+import { withInsertColumns } from '@sim/db/insert-columns'
+import { member, organization, organizationColumns } from '@sim/db/schema'
 import { generateId } from '@sim/utils/id'
 import { and, eq, ne } from 'drizzle-orm'
 import { acquireUserBillingIdentityLock } from '@/lib/billing/organizations/billing-identity-lock'
@@ -100,7 +101,7 @@ export async function createOrganizationWithOwnerTx(
     throw new OrganizationSlugTakenError(slug)
   }
 
-  await tx.insert(organization).values({
+  await tx.insert(withInsertColumns(organization, organizationColumns)).values({
     id: organizationId,
     name,
     slug,

diff --git a/apps/sim/lib/billing/organizations/membership.ts b/apps/sim/lib/billing/organizations/membership.ts
@@ -6,6 +6,7 @@
  */
 
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   account,
   credential,
@@ -18,6 +19,7 @@ import {
   subscription as subscriptionTable,
   user,
   userStats,
+  userStatsColumns,
   workspace,
   workspaceFiles,
 } from '@sim/db/schema'
@@ -1837,7 +1839,7 @@ export async function transferOrganizationOwnership(
 
       if (oldStats) {
         await tx
-          .insert(userStats)
+          .insert(withInsertColumns(userStats, userStatsColumns))
           .values({
             id: generateId(),
             userId: newOwnerUserId,

diff --git a/apps/sim/lib/billing/storage/tracking.ts b/apps/sim/lib/billing/storage/tracking.ts
@@ -17,7 +17,8 @@
  * writes any of them or deletes a locked row.
  */
 
-import { organization, userStats, workspace } from '@sim/db/schema'
+import { withInsertColumns } from '@sim/db/insert-columns'
+import { organization, userStats, userStatsColumns, workspace } from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { generateId } from '@sim/utils/id'
 import { isRecordLike } from '@sim/utils/object'
@@ -631,7 +632,7 @@ export async function checkAndIncrementStorageUsageInTx(
 
   if (!orgScoped) {
     await tx
-      .insert(userStats)
+      .insert(withInsertColumns(userStats, userStatsColumns))
       .values({
         id: generateId(),
         userId,

diff --git a/apps/sim/lib/copilot/chat/fork-chat-files.ts b/apps/sim/lib/copilot/chat/fork-chat-files.ts
@@ -1,3 +1,4 @@
+import { withInsertColumns } from '@sim/db/insert-columns'
 import { type WorkspaceFileRow, workspaceFileColumns, workspaceFiles } from '@sim/db/schema'
 import { createLogger } from '@sim/logger'
 import { getErrorMessage } from '@sim/utils/errors'
@@ -145,7 +146,7 @@ export async function planChatFileCopies(params: {
   // Ids and keys are generated client-side, so one multi-row insert suffices —
   // no per-row round trips while the fork transaction is held open.
   if (copyRows.length > 0) {
-    await tx.insert(workspaceFiles).values(copyRows)
+    await tx.insert(withInsertColumns(workspaceFiles, workspaceFileColumns)).values(copyRows)
     for (const source of rows) {
       const targetId = idMap.get(source.id)
       if (!targetId) continue

diff --git a/apps/sim/lib/credentials/__integration__/organization-personal-tokens.integration.ts b/apps/sim/lib/credentials/__integration__/organization-personal-tokens.integration.ts
@@ -1,11 +1,13 @@
 /** Real storage, encryption, migration, and authorization; no external GitLab calls. */
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   credential,
   credentialGroup,
   credentialGroupEnrollment,
   member,
   organization,
+  organizationColumns,
   permissions,
   resourcePolicy,
   user,
@@ -95,7 +97,7 @@ describe('organization personal tokens', () => {
         updatedAt: now,
       }))
     )
-    await db.insert(organization).values(
+    await db.insert(withInsertColumns(organization, organizationColumns)).values(
       [ids.org, ids.foreignOrg].map((id) => ({
         id,
         name: 'Token fixture organization',

diff --git a/apps/sim/lib/knowledge/__integration__/organization-mcp-search.integration.ts b/apps/sim/lib/knowledge/__integration__/organization-mcp-search.integration.ts
@@ -12,6 +12,7 @@ import { StreamableHTTPClientTransport } from '@modelcontextprotocol/sdk/client/
 import { CallToolResultSchema } from '@modelcontextprotocol/sdk/types.js'
 import type { Principal } from '@sim/auth/principal'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   apiKey,
   document,
@@ -25,6 +26,7 @@ import {
   oauthClient,
   oauthConsent,
   organization,
+  organizationColumns,
   organizationSearchIntegration,
   rateLimitBucket,
   user,
@@ -252,7 +254,7 @@ describe('organization Search MCP with real ingestion and current access', () =>
         updatedAt: new Date(),
       }))
     )
-    await db.insert(organization).values({
+    await db.insert(withInsertColumns(organization, organizationColumns)).values({
       id: otherOrganizationId,
       name: 'Other organization MCP fixture',
       slug: otherOrganizationId,

diff --git a/apps/sim/lib/knowledge/__integration__/seed-source-access-fixture.ts b/apps/sim/lib/knowledge/__integration__/seed-source-access-fixture.ts
@@ -1,5 +1,6 @@
 import { createHash } from 'node:crypto'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   credential,
   credentialGroup,
@@ -11,6 +12,7 @@ import {
   knowledgeExternalGroup,
   knowledgeExternalGroupMember,
   organization,
+  organizationColumns,
   permissions,
   user,
   workspace,
@@ -69,7 +71,7 @@ export async function seedKnowledgeAclFixture(
       updatedAt: now,
     },
   ])
-  await db.insert(organization).values({
+  await db.insert(withInsertColumns(organization, organizationColumns)).values({
     id: ids.organizationId,
     name: 'ACL integration organization',
     slug: ids.organizationId,

diff --git a/apps/sim/lib/knowledge/__integration__/slack-search-turns.integration.ts b/apps/sim/lib/knowledge/__integration__/slack-search-turns.integration.ts
@@ -1,10 +1,12 @@
 /** Exercises real PostgreSQL locks and constraints using only isolated, explicitly cleaned fixtures. */
 import type { OrganizationDelegatedPrincipal } from '@sim/auth/principal'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   copilotChats,
   credential,
   organization,
+  organizationColumns,
   outboxEvent,
   slackSearchInstallation,
   slackSearchTurn,
@@ -72,7 +74,7 @@ describe('durable Slack Search turns in PostgreSQL', () => {
       }))
     )
     await db
-      .insert(organization)
+      .insert(withInsertColumns(organization, organizationColumns))
       .values({ id: organizationId, name: 'Slack queue fixture', slug: organizationId })
     await db.insert(credential).values({
       id: credentialId,

diff --git a/apps/sim/lib/logs/execution/logger.ts b/apps/sim/lib/logs/execution/logger.ts
@@ -1,4 +1,5 @@
 import { db, dbFor } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   organization,
   usageLog,
@@ -698,7 +699,7 @@ export class ExecutionLogger implements IExecutionLoggerService {
     const startTime = new Date()
 
     const [workflowLog] = await execDb
-      .insert(workflowExecutionLogs)
+      .insert(withInsertColumns(workflowExecutionLogs, workflowExecutionLogColumns))
       .values({
         id: generateId(),
         workflowId,

diff --git a/apps/sim/lib/uploads/contexts/workspace/workspace-file-manager.ts b/apps/sim/lib/uploads/contexts/workspace/workspace-file-manager.ts
@@ -5,6 +5,7 @@
 
 import { randomBytes } from 'crypto'
 import { db } from '@sim/db'
+import { withInsertColumns } from '@sim/db/insert-columns'
 import {
   uploadSession,
   type WorkspaceFileRow,
@@ -266,7 +267,7 @@ async function insertWorkspaceFileMetadataInTx(
   metadata: WorkspaceFileMetadataInsert
 ): Promise<WorkspaceFileRow | undefined> {
   const [inserted] = await tx
-    .insert(workspaceFiles)
+    .insert(withInsertColumns(workspaceFiles, workspaceFileColumns))
     .values({
       ...omit(metadata, ['size']),
       sizeBytes: metadata.size,
@@ -1056,7 +1057,7 @@ export async function trackChatUpload(
 
       await db.transaction(async (tx) => {
         const [inserted] = await tx
-          .insert(workspaceFiles)
+          .insert(withInsertColumns(workspaceFiles, workspaceFileColumns))
           .values({
             id: fileId,
             key: s3Key,