README

A Laravel package that provides PDO ODBC connection drivers for Laravel 12, with special support for Snowflake database connections.

This project is forked from appsfortableau/laravel-pdo-odbc.

Description

This package extends Laravel's database functionality to support ODBC connections, with specific optimizations for Snowflake databases. It supports both ODBC connections and native Snowflake PDO driver connections.

Requirements

• PHP 8.0 or higher
• Laravel 12.0 or higher
• ODBC drivers for your database
• For Snowflake native connections: pdo_snowflake PHP extension

Installation

You can install the package via composer:

composer require henriknordstrom/laravel-pdo-odbc-patched

The package will automatically register its service provider.

Configuration

Add a new connection to your config/database.php file:

For general ODBC connections:

'connections' => [
    // ...
    'odbc' => [
        'driver' => 'odbc',
        'odbc_driver' => '/path/to/your/odbc/driver.so', // Required: absolute path to the ODBC driver
        'dsn' => 'your-dsn-string', // Optional: full DSN string
        'host' => 'your-host',
        'database' => 'your-database',
        'username' => 'your-username',
        'password' => 'your-password',
        'options' => [
            // PDO options
        ],
    ],
    // ...
],

For Snowflake via ODBC:

'connections' => [
    // ...
    'snowflake' => [
        'driver' => 'snowflake',
        'odbc_driver' => '/path/to/your/snowflake/odbc/driver.so',
        'host' => 'your-account.snowflakecomputing.com',
        'database' => 'your-database',
        'username' => 'your-username',
        'password' => 'your-password',
        'warehouse' => 'your-warehouse',
        'role' => 'your-role',
        'options' => [
            // PDO options
            'grammar' => [
                'query' => null, // Custom query grammar class
                'schema' => null, // Custom schema grammar class
            ],
            'processor' => null, // Custom processor class
        ],
    ],
    // ...
],

For Snowflake via native PDO driver:

'connections' => [
    // ...
    'snowflake_native' => [
        'driver' => 'snowflake_native',
        'host' => 'your-account.snowflakecomputing.com',
        'database' => 'your-database',
        'username' => 'your-username',
        'password' => 'your-password',
        'warehouse' => 'your-warehouse',
        'role' => 'your-role',
        'options' => [
            // PDO options
        ],
    ],
    // ...
],

Environment Variables

You can set the following environment variables in your .env file:

SNOWFLAKE_COLUMNS_CASE_SENSITIVE=false
SNOWFLAKE_DISABLE_FORCE_QUOTED_IDENTIFIER=false

Usage

Once configured, you can use the connection like any other Laravel database connection:

use Illuminate\Support\Facades\DB;

// Query using the ODBC connection
$results = DB::connection('odbc')->select('SELECT * FROM your_table');

// Query using the Snowflake connection
$results = DB::connection('snowflake')->select('SELECT * FROM your_table');

// Query using the Snowflake native connection
$results = DB::connection('snowflake_native')->select('SELECT * FROM your_table');

Features

• Support for general ODBC connections
• Specialized support for Snowflake databases
• Support for both ODBC and native Snowflake PDO driver connections
• Custom query grammar for Snowflake
• Custom schema grammar for Snowflake
• Custom processor for Snowflake
• Support for PHP 8.0+ with specialized statement classes

License

This package is open-sourced software licensed under the MIT license.

Author

• Henrik Nordstrom (henrik@webtractive.com)

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.