- Fix nuget packaging
- Allow the SQL parser to handle comments and update to latest FSharp Analyzers SDK
- Improvements to the SQL parser
- fixes dynamically applied parameters with more complex expressions
- Detect typed let bindings
- Let the analyzer continue its work when it comes across enum types
- Detect queries within sequential expressions or statements
- Detect queries within lambda expressions wrapped in single case unions
- Correctly retain selected column non-nullability when casted or aliased to another type
- Analyze SQL blocks from within lambda expressions
- Support for datetimeOffset and datetimeOffsetOrNone when reading columns of type timestamptz
- Analyze top level do expressions
- Analyze transaction parameter sets
- Allow for literal queries on transactions
- Analyze transaction queries
- The ability to suppress warning messages generated by the analyzer
- Remove NpgsqlFSharpAnalyzer.Core nuget package reference from the analyzer
- Parameter nullability inference for parsable queries
- Detecting the missing columns which are required for INSERT queries
- Better error messages when reading from a result set which doesn't return any columns
- Even better error messages that include whether types were arrays or not
- Better error messages when showing the possible functions to use.
- Warning when using Sql.execute and the query doesn't return a result set
- Support for text int and uuid arrays both when reading columns and writing parameters
- Updated FSharp.Analyzers.SDK to 0.5.0
- Trim whitespace from parameter names
- Fix aggressive syntactic matching
- Account for parameters of type
jsonband provide proper type mismatch error.
- Add Sql.executeRow(Async) and Sql.iter(Async) to the analysis
- Expand syntactic analysis to include searching through (async) computation expressions
- Search through nested modules and nested recursively
- Configure the connection string of the analyzer via a local file
- Update FSharp.Analyzers SDK 0.4.0 -> 0.4.1
- Update FSharp.Analyzers SDK 0.3.1 -> 0.4.0 with named analyzers.
- Update FSharp.Analyzers SDK and compiler services to align types.
- Update for Npgsql.FSharp 3.x to be able to analyze column reading functions as
{type}OrNoneinstead of{type}OrNull
- Update for Npgsql.FSharp 2.x
- Detect incorrect parameter type with code fixes
- Detect redundant parameters
- Detect nullable types and and suggest using proper function that handle null values
- Optimize number of database calls by reusing the database schema on each invokation
- Detect redundant query parameters in a clear warning message
- Provide code fixes and better suggestions for mismatched query parameters
- Remove duplicate messages about missing parameters
- Refactor and simplify parts of
InformatioSchemaandSqlAnalysis
- Provide column name fix suggestions when reading an unknown column
- Read parameters as soon as they written and implement proper code fixes.
- Read queries as soon as they written without expecting
Sql.executeReader
- Improved syntactic F# analysis in
Sqlmodule is used in combination with other generic functions
- Enable reading
[<Literal>]queries from the same module and add docs
- Detect type-mismatch when reading columns of type 'bool' from the database. Simplify parameter mismatch when there is only one parameter.
- Remove warning when there is no query provided (to avoid making a bother-ware analyzer)
- Proper packaging that includes third-party dependencies required for dynamic loading
- Initial release with working SQL analysis including syntax and type-checking