+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29)
+--- Thread: Support subqueries in BaseBuilder::from() (/showthread.php?tid=76151)
Support subqueries in BaseBuilder::from() - rmilecki - 04-17-2020
SQL databases support subqueries in FROM so it'd be great to have support for something like:
PHP Code:
$builder->from(function(BaseBuilder $builder) {
$builder->select('*');
$builder->from('news');
});
RE: Support subqueries in BaseBuilder::from() - kenjis - 03-05-2023
https://codeigniter4.github.io/CodeIgniter4/database/query_builder.html#subqueries