How to Generate the Advanced SQL Query with the Open AI | JetEngine

JetEngine 3.2.0 is around the corner, and… will you believe we decided to add some of the AI to our plugins too?

In this video, we will take a look at an AI feature — Open AI integration to generate Advanced SQL query.

To find the functionality easily, the SQL query type has been renamed to SQL/AI. Also, the Advanced mode switch has been moved to the first position and renamed to Advanced/AI mode.

How it works?
When Advanced/AI mode is enabled, just like before, the query builder switches to manual query input mode. An icon has been added to the main query input field to invoke the automatic query generation UI.

Clicking on the icon opens a popup for query generation. After entering the prompt and clicking the "generate query" button, the query generation process starts.
Hope its video was useful. Stay tuned for more!
#wordpress #ai #sqlquery #wordpressai
-------------

Leave your feedback on our GitHub

⚡Helpful instructions:

Get JetEngine plugin:

Choose Crocoblock subscription:

-------------

Templates used:

LaborTime — Dynamic Job Board Website for Elementor

-------------
☕LIKED THIS VIDEO? BUY JULIA A COFFEE
-------------

TIMESTAMPS

00:00 Introduction
00:35 Brief overview of JetEngine 3.2.0
02:32 Adding a custom query
04:01 Generating a query with AI
06:17 Applying the query to the listing
06:52 Adjusting the prompt

-------------
JetEngine playlist
-------------

Join us here:

[popopp]

Happy 5 year anniversary Crocoblock! The discount and the implementation of AI just convinced me to go and purchase the Unlimited Lifetime Croco plan. Thank you for the amazing tutorial Julia, keep up the good work!

[dorohan_ilya]

Wow! That's what we were waiting about!

[kevinrichter]

I really like the idea of AI for advanced SQL queries. That's actually a good use case and not just adding AI because it's a buzz word. Good job

Also nice to finally see some improvement for the DOM size of dynamic field/link. I've been using Bricks for a while now and the Elementor widgets are really unnecessarily bloated in comparison.

[Art-]

Woow, thank u Croco, love it✌️✌️✌️✌️🙏

[WickyDesign]

Nice! The SQL query with AI looks to be a great feature!

[kamalelboustani]

Thanks, that's great! Continue on that path

[MoxetKhanPK]

Excellent feature, especially for those with less knowledge of SQL. Question, the prompt/AI request to Open AI is free or paid?

[samuelepellizzari]

This looks awesome, @crocoblock! When is the update due out? I can’t wait! Keep up the great work!

[tajbinkhan]

This is really awesome. Now I can use query using my imagination.

If you are seeing crocoblock, I have a request to you. Please fix the dynamic date function for built in elementor countdown timer. Because it's not showing in the dynamic tags. It only works for jet element countdown timer. 🤗🤗🤗🤗

[wilsonrosagomes]

Sou do Brasil, não teria como fazer que o SQL AI funcionasse de acordo com o Idioma atual do Wordpress?

[qamarzaman-qz]

Can we add these as filter bassed on others plugins data, mean i am using a listing plugin can i made a query for that plugin meta data and make filter bassed on their data

[PeliPelo-ygzt]

This option dosent work for Sub key license, only for primar license.

I dont understand why.
We have more then 10 client and we use sub key for their websites and not primary key.

Hope Croco can allow AI query for sub key too.

Thank u

[fazelnasri]

Hello.how can we filter a series of categories that have a parent.
Whenever I enter the name of "PARENT", JetSmartfilter does not find it, but when I enter ID "PARENT", it filters its sub-categories. What is the reason?

[TurabWahand]

Using Jet Engine is very difficult. I do very hadwork to use the Jet Engine

[qamarzaman-qz]

An we apply these queries for filter 🥵