# \[IGN-7967\]Does reWriteBatchedInserts=true work on MSSQL? **URL:** \ **Category:** Ignition\ **Tags:** perspective, database\ **Created:** [December 10, 2025, 8:33pm UTC](https://forum.inductiveautomation.com/t/ign-7967-does-rewritebatchedinserts-true-work-on-mssql/112747 "2025-12-10T20:33:30Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [December 11, 2025, 1:44am UTC](https://forum.inductiveautomation.com/t/ign-7967-does-rewritebatchedinserts-true-work-on-mssql/112747/5 "2025-12-11T01:44:54Z")
Ignition wraps JDBC drivers in a vanilla JDBC connection pooling wrapper. The actual vendor-specific objects are **not** reachable without extensive reflection and behavioral work-arounds. Good luck. As it happens, you can pass arrays into the vanilla wrapper to be handed to PostgreSQL's `UNNEST()` function. Doesn't seem to work with other brands. > [@Taking a Dataset and Inserting it to a SQL temp table](https://forum.inductiveautomation.com/t/taking-a-dataset-and-inserting-it-to-a-sql-temp-table/83852/4): > > If you were using a competent database (the following is PostgreSQL), you can pass java arrays as arguments, and unnest() them in a FROM clause. For an example, I created a table in my psql forum playground called phrases, to be used in a join. When queried by itself, you get this dataset: "#NAMES" "prefix","suffix" "#TYPES" "str","I" "#ROWS","4" "Hello","1" "Good Bye","2" "Welcome to","3" "Whoa!","4" To go with that, in a custom property named lookups, I created the following unbound datase… > [@PostgreSQL array support](https://forum.inductiveautomation.com/t/postgresql-array-support/79507/6): > > UNNEST is in the SQL standard. Oracle has equivalent functionality with different syntax (the predefined collections tools, from what I understand). This functionality is also present (as UNNEST) in Google's cloud data warehouse. Presumably others. Microsoft simply lags other platforms, and has for many years. My bias towards DB-agnostic solutions is to avoid vendor lock-in. My bias towards PostgreSQL is due to their stated policy of hewing close to the standard wherever possible. This me… --- _[View the full topic](https://forum.inductiveautomation.com/t/ign-7967-does-rewritebatchedinserts-true-work-on-mssql/112747)._