use strict;
use warnings;
use HOP::Lexer 'make_lexer';

my $sql = <<END_SQL;
DECLARE DIMENSION "Enterprise Warehouse"."Charge Date" AS "Charge Date" UPGRADE ID 8444734 ON
	(
		  "Enterprise Warehouse"."Charge Date"."Charge Date Total" ) DEFAULT ROOT  "Enterprise Warehouse"."Charge Date"."Charge Date Total"
	DESCRIPTION {This is the date hierarchy for the Charge date.} 
	PRIVILEGES ( READ);
END_SQL

my @keywords = (
    'DECLARE DIMENSION',
    'AS',
    'UPGRADE ID',
    'DESCRIPTION',  
    'PRIVILEGES',  
    'ON',
    'DEFAULT ROOT'
);

my @sql   = $sql;
my $lexer = make_lexer(
    sub { shift @sql },
    [ 'KEYWORD', qr/(?i:@{[join '|', map {$_} @keywords]})/ ],
    [ 'UPRGADEID',   qr/\d+/                            ],
    [ 'COMMA',    qr/,/                            ],
    [ 'PAREN',   qr/\(/,      sub { [shift,  1] } ],
    [ 'PAREN',   qr/\)/,      sub { [shift, -1] } ],
    [ 'BRACE',   qr/\{/,      sub { [shift,  1] } ],
    [ 'BRACE',   qr/\}/,      sub { [shift, -1] } ],
#   [ 'TEXT',     qr/\([^\(]+\)\)/, \&text        ],
#   [ 'TEXT',     qr/({[^{]+})/, \&text  ],
    [ 'FQNAME3',  qr/("[^"]+".){2}\"[^"]+"/, \&text  ],
    [ 'FQNAME2',  qr/("[^"]+".)\"[^"]+"/, \&text  ],
    [ 'FQNAME1',  qr/("[^"]+")/, \&text  ],
    [ 'PERIOD',   qr/\./],
    [ 'SPACE',    qr/\s*/,     sub {}              ],
);

sub text {
    my ( $label, $value ) = @_;
    $value =~ s/["']//;
    $value =~ s/["']$//;
    $value =~ s/\".\"/./;
    return [ $label, $value ];
}

my $inside_parens = 0;
while ( defined ( my $token = $lexer->() ) ) {
     my ( $label, $value ) = @$token;
     $inside_parens += $value if 'PAREN' eq $label;
     print "current: $label $value \n";
     
     my $next = $lexer->('peek');
     my ( $next_label, $next_value ) = @$next;
     print "next $next_label $next_value \n";

#    next if $inside_parens || 'TEXT' ne $label;
        if ( defined ( my $next = $lexer->('peek') ) ) {
        my ( $next_label, $next_value ) = @$next;
        if ( 'COMMA' eq $next_label ) {
            print "$value\n";
        }
        elsif ( 'KEYWORD' eq $next_label && 'from' eq $next_value ) {
            print "$value\n";
            last; # we're done
        }
    }
}