Thank you, @Julius Kavay !

Sounds like a great idea of enhancement, thanks for sharing, @Julius Kavay !

Thank you, @Steve Pisani ! Thanks for sharing your experience! Yes, there can be different tools and combinations that provide results of decent quality - some friends of mine also consider Antigravity (and Gemini) or Claude Code with Cursor. I hope we'll end up with several working recipes to speed up the development of usual things x100 times.

Thank you, @Stephen Canzano ! That's interesting!

Thank you, Vitaly!

I see. And in my case some sets of parameters cause an anomaly, and it is not very effective to investigate it one-by-one

Thank you, @Vitaliy Serdtsev !

If enabled auditing gives the ability to see parameters, or the ability to copy/paste into SQL query tool a ready/made sql query that has been running in the system?

BTW, the global indeed contains the history! Thank you!

Thanks @David Hockenbroch ! Introduced an idea to get such a history as a system feature.

Thank you, @Robert Cemper ! Looks... complicated(?) to get an SQL query that causes anomalies? 

Thank you, @Dominic Chui !

Yes, this sounds safer. 

I'm still curious what does [identity] do here?

property id as %Library.BigInt [ identity ];

is it only for "Object" access and not for SQL?

Ah, I see - 

  VALUES (saleId,companyId,productId,saleDate,saleAmountUSD)

Impressive indeed.

I'm curious how and if the approach work if the id name in csv is diffent of "id", e.g.."CompanyId"?

Wow. Thanks @Vitaliy Serdtsev !

This is impressive. 

So if I understand properly, LOAD DATA guesses somehow that id is the idkey and primarykey here?

&sql(LOAD DATA FROM FILE 'C:\data\companies.csv'
  INTO dc_onetomany.companies(id,name,industry,description,website)
  USING {"from":{"file":{"header":true}}})

if AllowIdentityInsert =1?
 

Thanks @Dan Pasco !

So this $system.SQL.SetIdentityInsert(1) is a system-wide setting, right?

It looks like there is an option to have it as a parameter for a class as well, like @Vitaliy Serdtsev shared above  

Thanks Dan!

I’m having these property in my class that allows inserting ID values via SQL:

Parameter ALLOWIDENTITYINSERT = 1;

is it what you are talking about?

define a property as IDENTITY

I’m defining an index on an property id:

Index COMPANIESPKEY1 On id [ IdKey, PrimaryKey, SqlName = COMPANIES_PKEY1, Unique ];

Is it enough?

USEEXTENTSET=1 is a default one now if you use DDL to create a class. Maybe for ObjectScript is a default as well.

Yes. But we can omit it here (set 0) for simplification. Still the issue is in IDs

Thanks, @Dan Pasco! My task is to understand how can I better deal in IRIS if I need to export data into csv that contains records that reference IDs.  So I be able to import this data back into IRIS (same or another) preserving all the existing linkages.

I posted an example app illustrating the task.

What I came up with so far is:

introducing my own index as IDKEY and PrimaryKey - that works well for importing data from csv containing IDs.

But if when I’m introducing new records then with ObjectScript it wants me to create new IDs. This is where I have questions - how do I do it in the best way. You say I can try %Counter instead of %BigInt?