Okay, so seems like I also need to pass another named parameter operator in order to get the expected result:
return $query->where(column: 'is_active', operator:"=", value: true);
As of PHP.net stated in their Function Arguments docs:
PHP 8.0.0 introduced named arguments as an extension of the existing positional parameters. Named arguments allow passing arguments to a function based on the parameter name, rather than the parameter position. This makes the meaning of the argument self-documenting, makes the arguments order-independent, and
allows skipping default values arbitrarily.