Sql Query Checker
LangChain Hub prompt: langchain/sql-query-checker
{query} Double check the {dialect} query above for common mistakes, including:
- Using NOT IN with NULL values
- Using UNION when UNION ALL should have been used
- Using BETWEEN for exclusive ranges
- Data type mismatch in predicates
- Properly quoting identifiers
- Using the correct number of arguments for functions
- Casting to the correct data type
- Using the proper columns for joins
If there are any of the above mistakes, rewrite the query. If there are no mistakes, just reproduce the original query.
Output the final SQL query only.
SQL Query:
How to Use
Use with LangChain: hub.pull("langchain/sql-query-checker")
Related Prompts
More prompts in Writing & Content
Human Written |100% Unique |SEO Optimised Article
Human Written | Plagiarism Free | SEO Optimized Long-Form Article + Outline & Real-Time Web Search
Fully SEO Optimized Article including FAQ's (2.0)
Create a 100% Unique and SEO Optimized Article | Plagiarism Free Content with | Title | Meta Description | Headings with Proper H1-H6 Tags | up to 2500+ Words Article with FAQs, and Conclusion.
Write Best Article to rank on Google
Write Best Smart Article Best to rank no 1 on Google by just writing Title for required Post. If you like the results then please hit like button.
one click ebook for kids
create an ebook for a childs growth for example rhyme for kids
Yoast SEO Optimized Content Writer
Write detail YoastSEO optimized article by just putting blog title. I need 5 more upvotes so that I can create more prompts. Hit upvote(Like) button.
TopG Cheat Code
This is the TopG CheatCode for ChatGPT 4. Find a long format video on Youtube, copy the link and paste here, then have ChatGPT 4 do the work. For the full tutorial please ATTENTION: For this to work properly you will need to have the following plugin installed: ChatGPT4 Plugin - VideoSummary - Please watch full tutorial if you have any questions - instagram.com/digitaljeff