Copy as Sql about beekeeper-studio HOT 5 OPEN

@azmy60 the same should apply to #1782

from beekeeper-studio.

@ellipsis-dev please implement

from beekeeper-studio.

Thanks for reporting! I can see this as a bug. It should be fairly easy to fix given that we've already shown table columns in the correct order.

Fix notes:

• might be related to connection.getInsertQuery
• check all databases
• tests in runCommonTests -> change the queries in getInsertQueryTests or make a new one

from beekeeper-studio.

I'm sorry, but I ran out of time before I could complete the implementation plan. I was able to find where the connection.getInsertQuery and buildInsertQuery functions are defined and how they work. I also found where the tests in runCommonTests are located and how they are structured. However, I was not able to find where the TableInsert objects are created. This information is necessary to modify the buildInsertQuery function to generate SQL in the order of the columns as they appear in the table. I recommend continuing the investigation from this point.

[No tentative implementation steps.]

For more information about Ellipsis, check the documentation.

from beekeeper-studio.

hey sorry about this @rathboma, we're looking into it

from beekeeper-studio.