It would be great if we were able to drag a table into another project.

I'm sure we all have some standard tables we use again and again.

This way we could create a project with all our favourite tables and drag them over when we need them.

Yes, we already thought of this.
We will make disponible standard Joomla tables, Third project tables, and also let you the possibility to create third tables in your project that will be virtuals (not generateds in project).

The problem we face is for the sandbox. In facts, if the sandbox don't contain theses tables, it will lacks.
So, this work is in standby for now, and not a priority, but very nice functionality of course.


If you look in your code, you'll see how easy you can reach your datas and compose/filter the SQL query directly in the view file.
If the table you reach has been built with Cook, there are some added functionalites in the model (addJoin(), addWhere(), addOrder(), addGroupBy(), ... )

And also for security reasons, we don't want you access to the sandbox tables

The #__users table is replaced with a fake users table when you run your project in sandbox.

Yes I understand,,,looking forward to this

hi,
I was investigating new sql importer,
and was wondering if it works as virtual tables,

now I understand that is some other feature marked as "Third tables" in:
www.j-cook.pro/index.php/docs/feature-requests

Would it enable to integrate with other joomla components?

for example if I have a project with massive forking, from earlier versions of builder
and want to make a tiny modification in builder.

Super solution would be to move some functionality
to new component and only link to the proper tables form the main database.

making the story short:
I bump the topic

Yes, this is the idea.

This will require you to import the SQL structure into a new component in the builder, even if that component is not downloaded. Just linked to your main component.
So, whatever if it is a Joomla extension or a split component, this will work the same.

This feature is very long to achieve because I need to implement a lot of things. Both in the generator and in the builder interface. Structural changes, so I need to be very accurate to implement it.
I know it is asked by a lot of people, and has a big score in the Features Requests.

thx form reply,
to achive this for now I have been successfully experimenting with database views
mariadb.com/kb/en/mariadb/create-view/

its a workaround,
but it doesn't need any modifications in component,
only installation procedure of database changes a bit,
greetings and good luck!