Getting raw sql query to pass it to another query

[VRmnv]

In my project i use sql function which takes sql query, explains it and returns plan rows for this query. I use it for approximate rows counting in my large tables.

It looks like this:

CREATE OR REPLACE FUNCTION row_estimator(query text) RETURNS bigint
    LANGUAGE plpgsql AS
$$DECLARE
    plan jsonb;
BEGIN
    EXECUTE 'EXPLAIN (FORMAT JSON) ' || query INTO plan;
    RETURN (plan->0->'Plan'->>'Plan Rows')::bigint;
END;$$;

To use this function with bob i need builded sql query with binded params. Is there a way how to get this from a ViewQuery?

query := models.Events.Query()

[stephenafamo]

You can do either:

querySQL, args, err := models.Events.Query().Build(ctx)
// OR
querySQL, args, err := bob.Build(ctx, model.Events.Query())

[VRmnv]

Thanks for response! But i want sql with already binded params so i could paste it to my func.

not this:
SELECT * FROM ...
WHERE id = $1
1: id1

but this:
SELECT * FROM ...
WHERE id = 'id1'

[stephenafamo]

There is no current way to interpolate the query and args directly in Bob.

In Postgres, you can use EXPLAIN EXECUTE with a query that contains placeholders, but it doesn't seem possible in MySQL.

[VRmnv]

Okay! I'll figure some workaround with EXPLAIN EXECUTE! Thanks for your feedback