CVE and update status of the FreeBSD ports tree3,864 unaddressed CVEs in 671 portsAll times are CET
Port details

databases/p5-Mojo-SQL 0.02

Safely generate and compose SQL statements

Maintainer
sunpoet@FreeBSD.org
Packages
latest: 0.02
Upstream
up to date
Last update
to 0.02 · 17ccc863e3
Quarterly
2026Q4: 0.02
WWW
https://metacpan.org/dist/Mojo-SQL
Links
cgit · VuXML

Unaddressed and VuXML only (0)

No unaddressed CVE and nothing reported by pkg audit for the packaged version 0.02.

Fixed (0)

No VuXML entries for this package.

Problem reports (0) · open in Bugzilla, most recently changed first

None.

Commits (1)

Po-Chuan Hsieh (sunpoet) · 0.02
databases/p5-Mojo-SQL: Add p5-Mojo-SQL 0.02

Mojo::SQL safely generates and composes SQL statements. To prevent SQL injection
attacks, every ? in the input becomes a placeholder in the generated query, with
the corresponding value bound to it. Partial statements can be composed
recursively to build more complex queries.

Literal question marks can be escaped with ??.

Make partial statements optional to dynamically generate WHERE clauses.

If you need a little more control over the generated SQL query, you can also
bypass safety features with "sql_unsafe". But make sure to handle unsafe values
yourself with appropriate escaping functions for your database. For PostgreSQL
there are "escape_literal" and "escape_identifier" functions included with this
module.

For databases that do not support numbered placeholders like $1 and $2, you can
set a custom character with the placeholder option.
17ccc863e3