Query Builder

Run precise SQL queries directly against the Insuraviews database for highly customized analysis.

What it does: Provides direct database access for users who need specific data combinations not available through standard search and reporting tools. This access is through both a traditional SQL Editor, where users can create their own queries, or Natural Language Queries, where users can enter plain language questions, and a query will be generated for you.

Who should use this:

• Data analysts and actuaries comfortable with SQL

• Users needing complex data relationships

• Teams requiring specific data formats for internal systems

• Advanced users who want maximum flexibility in data extraction

How to use - SQL Editor:

1. Access "Query Builder" and the "SQL Editor" tab

2. Write Your Query: Use SQL syntax to specify exactly what data you need

   • Access tables for filings, companies, states, rate changes, and more

   • Join multiple data sources for complex analysis

   • Apply custom filters and calculations

3. Test and Validate: Preview results before running full query

4. Execute Query: Run against live database

5. Export Results: Download your results as a CSV file

Example Query Types:

• Complex Rate Analysis: "Show me all auto rate increases >10% in California and Texas from companies with >$1B premium, including their loss ratios"

• Temporal Patterns: "Compare rate filing timing patterns between Q1 and Q4 over the last 3 years"

• Regulatory Trends: "Identify states with fastest approval times for homeowners rate increases"

• Market Positioning: "Calculate market share changes based on rate competitiveness by territory"

Database Schema Access:

• Complete documentation of available tables and fields

• Data dictionary explaining field definitions and relationships

Query Builder - SQL Editor

How to Use - Natural Language

1. Access "Query Builder" and the "Natural Language" tab

2. Write your Question: No need for SQL syntax or technical knowledge, Natural Language allows for standard questions to be converted into SQL

3. Generate SQL: Converts the question to an SQL query, and then runs the query against the live database

   • Generated query is provided to the user for options to copy and edit it in the SQL Edito

4. Export Results: Download your results as a CSV file

Example Questions:

• "What is the premium-weighted rate impact for Homeowners filings in the last 12 months?"

• "Which DOI reviewers have completed the most filings?"

• "List the most common rating factors used for Personal Auto filings."

Query Builder - Natural Language

Safety Features:

• Read-only access ensures data integrity

• Query timeout limits prevent system overload

• Result size limits for manageable outputs

• Query history for reproducing previous analysis