PS Query & SQL

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I have used ChatGPT (I call it Chet, although I do like the "creepy friend" term, Sarah) to help figure out issues with my queries.  It has helped me detect issues with my expressions too. I generally use it as a last resort when I can't figure something out or if I'm pressed for time. It has been helpful. 

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I have used ChatGPT for when I get into problems with writing queries that are very complex.  I always have to make sure to tell it that this is for PSQuery and has constraints.  It does try to work around those, most of the time (not always).  I also use it to help me write or increased the efficiency of SQL that I am writing for Oracle Analytics that is used for reports in SFA. Sometimes I will provide the table and fields and just write what I am looking for in plain English and it can create something from which I can work with.

I have learned quite a bit.  It's not always 100%, but it is pretty damn good. 

I have used ChatGPT (I call it Chet, although I do like the "creepy friend" term, Sarah) to help figure out issues with my queries.  It has helped me detect issues with my expressions too. I generally use it as a last resort when I can't figure something out or if I'm pressed for time. It has been helpful. 

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I have used ChatGPT to help with expressions within my queries.  I have also put in an existing sql and then tell it what I functionally want it to do and ask it to add to the sql within PeopleSoft.  It doesn't always get you there the first time due to some of the limitations in PSQUERY, but it does get you to a jumping off point.

I have used ChatGPT for when I get into problems with writing queries that are very complex.  I always have to make sure to tell it that this is for PSQuery and has constraints.  It does try to work around those, most of the time (not always).  I also use it to help me write or increased the efficiency of SQL that I am writing for Oracle Analytics that is used for reports in SFA. Sometimes I will provide the table and fields and just write what I am looking for in plain English and it can create something from which I can work with.

I have learned quite a bit.  It's not always 100%, but it is pretty damn good. 

I have used ChatGPT (I call it Chet, although I do like the "creepy friend" term, Sarah) to help figure out issues with my queries.  It has helped me detect issues with my expressions too. I generally use it as a last resort when I can't figure something out or if I'm pressed for time. It has been helpful. 

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

Like Michelle, I use AI (usually Gemini) to help tweak expressions. 

I have also used it to created comma delimited lists, which is always a pain. My prompt is "Make this a comma separated value list, with each valued enclosed in single quote marks."  This produces output like: ('red', 'green', 'blue', 'orange').  I have other ways to create a list like this, but AI is by far the fastest. 

I have used ChatGPT to help with expressions within my queries.  I have also put in an existing sql and then tell it what I functionally want it to do and ask it to add to the sql within PeopleSoft.  It doesn't always get you there the first time due to some of the limitations in PSQUERY, but it does get you to a jumping off point.

I have used ChatGPT for when I get into problems with writing queries that are very complex.  I always have to make sure to tell it that this is for PSQuery and has constraints.  It does try to work around those, most of the time (not always).  I also use it to help me write or increased the efficiency of SQL that I am writing for Oracle Analytics that is used for reports in SFA. Sometimes I will provide the table and fields and just write what I am looking for in plain English and it can create something from which I can work with.

I have learned quite a bit.  It's not always 100%, but it is pretty damn good. 

I have used ChatGPT (I call it Chet, although I do like the "creepy friend" term, Sarah) to help figure out issues with my queries.  It has helped me detect issues with my expressions too. I generally use it as a last resort when I can't figure something out or if I'm pressed for time. It has been helpful. 

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I haven't used AI for this (or much honestly).  I think for me, it's mostly the fact that I am a kinesthetic learner, and really need to do a thing for myself to learn/understand it.   It will almost certainly take me longer the first time, but (I hope) would save me time in subsequent needs for similar expressions/SQL.

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

------------------------------
Dana Pawlowicz
Business Systems Analyst Sr - ERP
University of Cincinnati
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

I have mostly used different models to help with brainstorming different solutions that I then test to see how they work in PS query.  By far the most common task I have done is SQL tuning suggestions. This has been particularly helpful due to the changes introduced by the most recent updates to CS/PT (CS 9.2.034, PT 8.61.13), which appear to alter the query execution plans significantly.  I have noticed that sometimes an in list runs faster than an exists subquery until a PT update, and then it is the opposite.  Anything to help come up with different ideas on how to change the code has been useful.  

I have leaned towards Anthropic's Claude and Google's Gemini due to their suggestions have generally worked better.  So far, no tool has be much better than another, and with SQL tuning, I can get contradicting answers depending on the model.  No matter what model or agent I use, I usually need to build in the limitations of PS query, like not being able to use Common Table Expressions (CTEs), which would be very helpful, but I doubt PS query will ever have that.  

Thanks @Dana Pawlowicz for bringing up this topic. It has been interesting to see the range of answers, as well as remembering to use "ON OVERFLOW TRUNCATE."

------------------------------
Ross Nolan
Data and Reporting Analysis
University of California-Berkeley
rvnolan@berkeley.edu
------------------------------

Original Message:
Sent: 09-23-2025 09:32 AM
From: Dana Pawlowicz
Subject: Are you using AI at all with your query/SQL?

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

------------------------------
Dana Pawlowicz
Business Systems Analyst Sr - ERP
University of Cincinnati
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

Yes, I will ask Microsoft Copilot for help with SQL. I'll copy a complex SQL I don't understand and ask it to break it down for me. Sometimes I ask it to modify a SQL for me. I know what I want to do, but maybe I don't know the syntax for it. I am not limited to PS Query. It is helpful.

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?  

Yes, I will ask Microsoft Copilot for help with SQL. I'll copy a complex SQL I don't understand and ask it to break it down for me. Sometimes I ask it to modify a SQL for me. I know what I want to do, but maybe I don't know the syntax for it. I am not limited to PS Query. It is helpful.

I used chatgpt for the first time today to fix my PS Query expression and was just wondering if you guys have done this at all?  I had a LISTAGG expression and it was throwing a "string concatenation too long" error so I went into chatgpt and said, this is my expression and this is the error I'm getting, can you fix it?

And it did.  It added "ON OVERFLOW TRUNCATE WITHOUT COUNT" which I can honestly say I've never used before.

This query is a bit of a beast and runs long so I might run it in batch, but I am now getting this data back without an error message so I'm happy with the results.

So, have you used AI/chatGPT (something else?) in your SQL world?