users are able to update their own data

According to PeopleBooks.."By default, the Component Processor does not allow an user to make any changes to a record if a record contains an EMPLID key field and its value matches the value of the user's EMPLID" . Function AllowEmplIdChg(true) should be used in order to allow users to update their own data.

SQL PeopleCode requirment for long field

If the long field is not enclosed within %TextIn, then the SQL will work with long field values up to 255 characters long. Anything over that will cause a "Fatal SQL error has occurred" message to pop up - so it's hard to pick up in testing.

INSERT INTO PS_SOME_RECORD(EMPLID
, LONG_FIELD1
, LONG_FIELD2)
VALUES (:1
,%TextIn(:2)
,%TextIn(:3))

SQR: Keeping leading zeros in CSV file

Add '=" to the fild such as emplid or business unit in order to keep leading zeros in sqr generated CSV file as example below:
Write #OutFile_xls From
'='
'
$EmplID
'",="'
$business_unit
','
$empl_rcd
','
$Field
','
$Errmsg
'