Search returns "raw" schemas before other schemas

[evansd]

Searching for tables which appear in both "cooked" and "raw" schemas returns the raw schema first, which confuses users.

For example:

Thread where this confusion arose:
https://bennettoxford.slack.com/archives/C04DVD1UQC9/p1709896596557359

[evansd]

This could be solved using the same approach as used here:

• Heavily deprioritise legacy pages in search results opensafely/documentation#1595

We'd need to update the code which gets information about the schemas to return an is_raw flag for each schema:

ehrql/ehrql/docs/schemas.py

Lines 43 to 52 in f5b0d5f

	schemas.append(
	{
	"name": name,
	"dotted_path": dotted_path,
	"hierarchy": hierarchy,
	"docstring": docstring,
	"implemented_by": implemented_by,
	"tables": sorted(module_tables, key=lambda t: t["name"]),
	}
	)

Probably this would just be based on the module name as I don't think we have anything more structured to use here.

Then the code which renders the schemas to Markdown would need to add a metadata header to the page which configures the search boost appropriately:

ehrql/ehrql/docs/render_includes/schemas.py

Lines 40 to 63 in f5b0d5f

	SCHEMA_TEMPLATE = """\
	# <strong>{name}</strong> schema
	{implemented_by_list}
	{docstring}
	``` {{.python .copy title='To use this schema in an ehrQL file:'}}
	from {dotted_path} import (
	{table_imports}
	)
	```
	{table_descriptions}
	"""
	def render_schema(schema):
	return SCHEMA_TEMPLATE.format(
	**schema,
	implemented_by_list=implemented_by_list(schema["implemented_by"], depth=2),
	table_imports=table_imports(schema["tables"]),
	table_descriptions=table_descriptions(schema["tables"]),
	)

For raw pages I imagine something like this would do the trick, but we'll need to experiment with the boost values a bit:

---
search:
  boost: 0.001
---