Can Workbench queries support Common Table Expressions?

lauraanderson

Can Workbench queries support Common Table Expressions (CTE's)?

Are the CTE's supported dependent on the flavor of SQL database the user is connecting to?

 

Thanks!

 

kshah008

Hi all,

 

Can anybody help @lauraanderson with their question?

 

Thanks!

Smu

Hello @lauraanderson

 

Workbench sends the query exactly as it's typed to the ODBC driver. So if the driver allows CTEs workbench should be able to handle it as well.

kshah008

@lauraanderson, did Smu's reply help answer your question?