PS Query & SQL

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 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 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. 

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 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 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
------------------------------

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.

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.