Join multiple sql tables

[laigor]

Please tell me how to get source parameters inside the plugin? I want to supplement with data from other tables by making SQL queries inside pre_event.

[nMessage]

Try writing a view? eg for postgresql

CREATE VIEW meilisearch_view AS
SELECT
    users.id_key,
    other.foo,
FROM
    users
LEFT JOIN
    other ON users.id_key = other.user_id;

[laigor]

If I use views in mysql, database changes are not tracked.