Support prepared statement arguments in the LIMIT clause

[WeCodingNow]

Is your feature request related to a problem or challenge?

DataFusion: v41.0.0

I want to be able to write the following query as a prepared statement:

PREPARE get_N_rand_ints_from_last_run(INT) AS
SELECT id
FROM
    "test"
WHERE run_id = 'foo'
ORDER BY random()
LIMIT $1

I get the following error message:

Error during planning: Unexpected expression in LIMIT clause

It is impossible, as as it seems that the LIMIT clause supports only constants in it

datafusion/datafusion/sql/src/query.rs

Lines 101 to 114 in ac74cd3

	let fetch = match fetch {
	Some(limit_expr)
	if limit_expr != sqlparser::ast::Expr::Value(Value::Null) =>
	{
	let expr = self.sql_to_expr(
	limit_expr,
	input.schema(),
	&mut PlannerContext::new(),
	)?;
	let n = get_constant_result(&expr, "LIMIT")?;
	Some(convert_usize_with_check(n, "LIMIT")?)
	}
	_ => None,
	};

Postgres does support using prepared statement's arguments in the LIMIT clause:

Describe the solution you'd like

Support using prepared statement arguments in the LIMIT clause

Describe alternatives you've considered

inapplicable

Additional context

No response

[jonahgao]

I think it can be easily supported after #9821

[WeCodingNow]

I think it can be easily supported after #9821

This issue refers to the PR #9815 that was closed due to inactivity; is there any way to make a similar PR?

[jonahgao]

I think it can be easily supported after #9821

This issue refers to the PR #9815 that was closed due to inactivity; is there any way to make a similar PR?

I plan to work on it in the next few days.